Changes:
- add handling of %i in log_line_prefix
- add handling of [, ], ( and ) in log_line_prefix
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
Counting number of distinct elements
When I was working for one of customers we found some strange thing. We needed to found number of distinct sessions per day. Table layout was very simple:
Silencing \commands in .psqlrc
I'm using .psqlrc file to set my preferable environment in psql. But I got lately annoyed by it confirming the changes every time I run psql:
Waiting for 8.4 – partial-match support in GIN, and sequence restart
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
Continue reading Waiting for 8.4 – partial-match support in GIN, and sequence restart
Waiting for 8.4 – CASE in pl/PgSQL
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Waiting for 8.4 – function stats
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).
Waiting for 8.4 – pl/PgSQL RAISE
Today we have one new feature – extension of plpgsql's RAISE command.
Prepared statements gotcha
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").
Waiting for 8.4 – psql vs. tabs + wrapped output
Today I will describe 2 new patches which modify psql:
Continue reading Waiting for 8.4 – psql vs. tabs + wrapped output
MySQL’s timestamp in PostgreSQL
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.