Archiwizowane September, 2008

miałem urlop. to zdanie jest istotne, bo urlopy biorę rzadko. nie lubię. i jak się okazuje - są po etmu istotne powody. w lipcu pojechałem z moją panią i dziećmi samochodem do bułgarii. razem z nami pojechali znajomi - ale już ...

On 23rd of September, Heikki Linnakangas committed patch that was written by Radek Strnad (actually committed patch is a stripped-down version of original). What it does? It adds ability to have (finally!) different collation order and character categories for different databases.

September 18th, 2008 by depesz | Tags: , | 3 comments »

Tak się złożyło, że jestem klientem CitiBanku. Mam u nich konto biznesowe, i z tej okazji muszę co jakiś czas korzystać z ich systemu webowego. Już parę razy do nich pisałem, że system jest wolny, nie zawsze wyświetla wszystkie informacje, ma problemy ...

Let's assume we have a simple table: CREATE TABLE objects ( id serial primary key, category INT4 ...

Takahiro Itagaki wrote, and Tom Lane committed nice patch, which I personally find really helpful: Add a duration option to pgbench, so that test length can be specified in seconds instead of by number of transactions to run. Takahiro Itagaki

September 13th, 2008 by depesz | Tags: | No comments »

Changes: normalize BEGIN/START ... statements normalize END/COMMIT ... statements normalize ROLLBACK/ABORT ... statements SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

Great (and admittedly long overdue) patch by Tom Lane: Make pg_dump --data-only try to order the table dumps so that foreign keys' referenced tables are dumped before the referencing tables. This avoids failures when the data is loaded with the FK constraints ...

September 7th, 2008 by depesz | Tags: | No comments »

Changes: fix regexps for header - now it will be possible to sensibly analyze logs with informations about log archiving. SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

September 6th, 2008 by depesz | Tags: , , , , | 2 comments »

Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely - it simplifies changing definition of functions.