Absolutely great post about designing database schema to contain information about marriages and partnerships with emphasis on changes brought to us by modern day - gay marriages, non-trivial sex/gender identities and polygamy.

April 29th, 2008 by depesz | Tags: , , , , | Comments Off on Waiting for 8.4 – generate_subscripts

Yesterday, Alvaro Herrera committed patch written by Pavel Stehule which adds generate_subscripts(...) function.

Tom Lane committed his patch which modifies output of "EXPLAIN VERBOSE" command.

unfrotunatelly i can't point you to message in archives, as there is some problem with them, and i dont see posts newer than "Fri Apr 04 12:00:08 2008". this patch was written by tomas doran, and commited by bruce momjian:

April 2nd, 2008 by depesz | Tags: , , , , | 5 comments »

another very interesting addon. pavel stehule wrote, and tom lane commited "execute using" in plpgsql.

March 31st, 2008 by depesz | Tags: , , , | 1 comment »

in today "waiting for 8.4" i will show you 3 new patches. all of them add new functionality to psql - the most common tool to access postrgesql database.

March 28th, 2008 by depesz | Tags: , , , , , , | 4 comments »

another new, cool feature commited by tom lane: "Support statement-level ON TRUNCATE triggers." original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).