select * from depesz;

CONTEXT messages are quite informative, but when you don’t need them, they can be real pain in the eyes:

psql:trees.sql:68: NOTICE: Adding tree structures to table public.testit.
CONTEXT: SQL function "add_tree_structure" statement 1
psql:trees.sql:68: NOTICE: Tree table will be public.testit_tree.
CONTEXT: SQL function "add_tree_structure" statement 1
psql:trees.sql:68: NOTICE: Primary key in source table is: id
CONTEXT: SQL function "add_tree_structure" statement 1

I mean – I know the context. I’m writing the sql file right now, how to disable it?

- MORE -

Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing:

- MORE -

Today we have two interesting patches:

• patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes
• patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences

- MORE -

Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:

- MORE -

Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).

- MORE -

Today we have one new feature – extension of plpgsql’s RAISE command.

- MORE -

Friend from my previous employer told me that plans of execution of prepared statement, and the same statement run “as it” are different.

Well, I checked and this is what I found (it’s not shocking, it’s actually quite obvious, but You have to think about it for a while to “get it”).

- MORE -

Today I will describe 2 new patches which modify psql:

- MORE -

MySQL has this nifty/annoying feature/bug of special data type “TIMESTAMP”. It is like a DATETIME, but it gets automatically updated whenever you modify the row.

I’ll try to add the same feature to PostgreSQL.

- MORE -

PostgreSQL 8.3 brought us many great new features. Among them were concurrent autovacuum, enums, tsearch in core.

On of the changes though made a lot of people dislike 8.3. It was removal of implicit casts.

- MORE -