kaiv.wordpress.com
March | 2008 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2008/03
Don’t rely on luck, count on it. Archive for March, 2008. March 2, 2008. Defining constants in Pl/pgSQL, with a twist. Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction. Skytools database scripting framework & PgQ. PostgreSQL cluster: partitioning with plproxy (part II). Blog at WordPress.com. Follow “ (- -) on PostgreSQL”. Get every new post delivered to your Inbox.
kaiv.wordpress.com
Getting current time inside a transaction | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/11/02/getting-current-time-inside-a-transaction
Don’t rely on luck, count on it. Getting current time inside a transaction. This has already been on the lists but i hope it will be useful to somebody who has not time to read all of them. If you are doing stuff inside a transaction you may have noticed that the the results of NOW(), CURRENT TIMESTAMP etc. will always return the same value, eg. Test=# begin; BEGIN test=# select timeofday(): timestamptz; timeofday - - - - - - - - - - - - - - - - 2007-11-02 17:01:15.042648 02 (1 row) test=# select tim...
kaiv.wordpress.com
November | 2007 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/11
Don’t rely on luck, count on it. Archive for November, 2007. November 2, 2007. Getting current time inside a transaction. Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction. Skytools database scripting framework & PgQ. PostgreSQL cluster: partitioning with plproxy (part II). Create a free website or blog at WordPress.com. Follow “ (- -) on PostgreSQL”. Get every new post delivered to your Inbox.
kaiv.wordpress.com
July | 2007 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/07
Don’t rely on luck, count on it. Archive for July, 2007. July 27, 2007. PostgreSQL cluster: partitioning with plproxy (part I). July 23, 2007. Decreasing the index size on wide columns. Posted in data mining. July 19, 2007. Last row in a history table. July 19, 2007. Faster insert for multiple rows. July 17, 2007. NOW() vs ‘NOW’. Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction.
kaiv.wordpress.com
December | 2007 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/12
Don’t rely on luck, count on it. Archive for December, 2007. December 11, 2007. Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction. Skytools database scripting framework & PgQ. PostgreSQL cluster: partitioning with plproxy (part II). Create a free website or blog at WordPress.com. Follow “ (- -) on PostgreSQL”. Get every new post delivered to your Inbox. Build a website with WordPress.com.
kaiv.wordpress.com
Defining constants in Pl/pgSQL, with a twist | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2008/03/02/defining-constants-in-plpgsql-with-a-twist
Don’t rely on luck, count on it. Defining constants in Pl/pgSQL, with a twist. CONSTANT C ORDER DELIVERED int :=1;. Blocks in your functions declare section to keep the code readable. This gets extremly annoying when there are let’s say 20 different statuses, should i declare them all in the DECLARE section or just the ones used by the function? However this can be avoided by a small trick…. Handling constants as record types attributes. Note that this kind of approach also has it’s drawbacks: The ...
kaiv.wordpress.com
Skytools database scripting framework & PgQ | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/10/19/skytools-database-scripting-framework-pgq
Don’t rely on luck, count on it. Skytools database scripting framework & PgQ. PgQ is the queueing solution that empowers the londiste replication. When you have londiste installed in your database you have also PgQ installed. So first of all let’s bring out a few key points why it’s better to use PgQ instead of queue tables:. Performance : cleanup is done by rotating between 3 tables and using truncate to get rid of old data, no need for delete queries. Select * from pgq.create queue('mailer');. More inf...
kaiv.wordpress.com
October | 2007 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/10
Don’t rely on luck, count on it. Archive for October, 2007. October 19, 2007. Skytools database scripting framework & PgQ. Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction. Skytools database scripting framework & PgQ. PostgreSQL cluster: partitioning with plproxy (part II). Create a free website or blog at WordPress.com. Follow “ (- -) on PostgreSQL”. Get every new post delivered to your Inbox.
kaiv.wordpress.com
September | 2007 | <(-_-)> on PostgreSQL
https://kaiv.wordpress.com/2007/09
Don’t rely on luck, count on it. Archive for September, 2007. September 2, 2007. PostgreSQL cluster: partitioning with plproxy (part II). Welcome to the archives here at (- -) on PostgreSQL. Have a look around. Defining constants in Pl/pgSQL, with a twist. Getting current time inside a transaction. Skytools database scripting framework & PgQ. PostgreSQL cluster: partitioning with plproxy (part II). Blog at WordPress.com. Follow “ (- -) on PostgreSQL”. Get every new post delivered to your Inbox.