Changes:
- normalize BEGIN/START … statements
- normalize END/COMMIT … statements
- normalize ROLLBACK/ABORT … statements
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
Waiting for 8.4 – ordered data loading in pg_dump
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 already active. If no such ordering is possible because of circular or self-referential constraints, print a NOTICE to warn the user about it.
What it exactly means?
Continue reading Waiting for 8.4 – ordered data loading in pg_dump
pgsql-tools/analyze.pgsql.logs.pl
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
Waiting for 8.4 – \ef in psql
Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely – it simplifies changing definition of functions.
Hunting “idle in transactions”
If you ever encountered “idle in transaction" connections, you most likely hate them. I know, I personally hate them. They interfere with most of “cool toys" like replication, vacuum, DDL queries.
So, when I saw them on a database I was looking on, I decided to act.
Easier to say, difficult to do. How to fix the problem?
NULLs vs. NOT IN()
Friend of mine found something that he thought looked like a bug in Pg.
Very simple query:
select * from table where id not in (select field from other_table)
was not returning any rows, despite the fact that there definitely are some “ids" that are not in other_table.field. Why is that?
Waiting for 8.4 – case insensitive text ( citext )
On 29th of July, Tom Lane committed patch written by David E. Wheeler, which added new contrib module: citext.
Continue reading Waiting for 8.4 – case insensitive text ( citext )
Waiting for 8.4 – UNION / INTERSECT / EXCEPT
During last month or so, Tom Lane commited changes in PostgreSQL, which were foundations for adding hash-based versions of popular features.
I already described first such feature – DISTINCT.
Now, there were 3 more commits which were related to this:
Continue reading Waiting for 8.4 – UNION / INTERSECT / EXCEPT
Removing elements from arrays
Cezio wrote post about removing elements from arrays in PostgreSQL.
Unfortunately his blog engine requires registration before comment, which I don't like, so I decided to comment using my own blogspace.
Waiting for 8.4 – hash based DISTINCT
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.