Archiwizowane July, 2009

July 22nd, 2009 by depesz | Tags: | 7 comments »

I just checked my WordPress dashboard, and it says: 1,000 Posts 1,847 Comments First entry was posted on 13th of May 2006 - 1166 days ago. During this time I had 2 breakdowns when I said that I close the blog, switched language, and moved ...

On 205h of July Andrew Dunstan committed patch by Andres Freund : Log Message: ----------- DROP IF EXISTS for columns and constraints. Andres Freund.

July 13th, 2009 by depesz | Tags: , , , , , , | 1 comment »

Today, on irc (#postgresql on freenode.net) Dim mentioned about writing median calculation code. It got me thinking, and consequently writing my version of median calculation code.

July 10th, 2009 by depesz | Tags: , , , | No comments »

I had today a very weird situation. From my laptop, I ssh to another system, and from there to yet another. On this final system I noticed that vim starts relatively slow. i.e. this command: time vim -u /dev/null -c ":q" returned time in ...

Every so often you need to get list of unique elements in some column. The standard way to do it is: select distinct column from table; or select column from table group by column; The only problem is that it's slow - as it ...

#!/usr/bin/bf +++++[>++[>>++++>+++++++>+++>+>++++> ++++>++++>+++++++++.--.+. .--..+++.---.

Also yesterday, and also Peter Eisentraut, committed patch by Guillaume Smet, which: Add log_line_prefix placeholder %e to contain the current SQL state Author: Guillaume Smet

Yesterday Peter Eisentraut committed a patch, written by Damien Clochard, that modifies \d output in psql: Have \d show child tables that inherit from the specified parent As per discussion, \d shows only the number of child tables, because that could be ...

July 3rd, 2009 by depesz | Tags: , , | 4 comments »

Everybody wrote that 8.4 was released, so it's not a news now. But. Starting from yesterday, my own PostgreSQL reports it's version like this: # select version(); ...