On 25th Robert Haas committed patch which adds first of 'CREATE IF NOT EXISTS' commands: Log Message: ----------- CREATE TABLE IF NOT EXISTS. Reviewed by Bernd Helmle.
Let's imagine simple situation - you have table of objects (each with id), and you want objects 3, 71, 5 and 16. And in that order! How to do it?
One of the questions that pop up frequently on IRC is how to see queries are now executed on the server, and what queries were earlier. Theoretically answer to this is simple - pg_stat_activity and log_min_duration_statement. Or log_statement. What is the ...
On 20th of July, Robert Haas committed (and later committed change to it) patch which adds another \* command to psql: Log Message: ----------- Add \conninfo command to psql, to show current connection info. David Christensen. Reviewed by Steve Singer. Some further changes ...
Generally I write about new features, but this change is relatively important. Yesterday, on 20th of July, Robert Haas committed following change: Log Message: ----------- Change the default value of standard_conforming_strings to on. This change should be publicized to driver maintainers at once and release-noted as ...
As of now, I am happy user of 9.1devel version of PostgreSQL: =$ psql -c 'select version()' ...
OmniPITR project that I wrote about some time ago is going on. Just today I finished tests for omnipitr-backup-slave - part of OmniPITR which lets you make hot-backups of WAL-slave machine - without any additional load on master. As previously - please ...
Today, Mattias|farm on IRC asked how to create primary key using HASH index. After some talk, he said that in some books it said that for "=" (equality) hash indexes are better. So, I digged a bit deeper.
Every so often you might need to find a value regardless of which column it's in. Of course not in application code, as this would be very slow. But you might be in situation where you just don't know where did ...
Relatively soon we will have 9.0, and we will move with development to 9.1 (we as in: PostgreSQL community, I don't know C so I can't help developing myself, but I will at least try to keep up with changes ...
