Archiwizowane July, 2010

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 of now, I am happy user of 9.1devel version of PostgreSQL: =$ psql -c 'select version()' ...