Archiwizowane March, 2008

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.

there is this quite old, but pretty functional concept: keyboard shortcuts. you know it - you press ctrl-s, and your editor saves currently-edited file. my problem is that there are some standard cases when i would really love to have this ability ...

there is this situation: multiple people have to have access to single system account on unix/linux. you are one of them, but you really want to have your own environment. aliases, path, and so on. problem? others dont want your changes. is ...

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).

previously, we talked about procmail filters in exim+sql system. today we will add some nifty aliases capabilities.

March 24th, 2008 by depesz | Tags: , | No comments »

on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:

March 22nd, 2008 by depesz | Tags: , | 4 comments »

yesterday, tom lane committed another great feature. actually it's so great, that i really wonder how could i live without it earlier. patch came from itagaki takahiro, and was heavily modified by tom. what it does?

March 21st, 2008 by depesz | Tags: , , | 10 comments »

simple brain teaser: given standard unix crontab what is the longest possible interval between calls to the same program? for example: 15 */2 * * * /bin/echo x has interval 2 hours. what is the longest possible? and how to make it?

znajomy powiedział mi dziś o jakiejś wtopie mailowej z tej okazji wszedłem na ich stronę. i oczom mym ukazała się strona:

there are this situations where you need (or you think you need) to get multiple values from sequence. for example - you're importing lots of data: some objects, some objects which relate to base objects, and so on. of course you can ...