[GENERAL] Partitionning by trigger

2013-02-26 Thread Ali Pouya
to that of the direct insertion ? I use PostgreSQL 9.2.3 in Linux Fedora 2.6 environment. I can send a simplified self contained test case if required. Thanks for your answer Best Regards Ali Pouya

Re: [GENERAL] Monitoring streaming replication from standby on Windows

2013-01-04 Thread Ali Pouya
2012/12/14 Karl Denninger k...@denninger.net If it's whether the replication is caught up, I have a small C program that will do that and have posted it before (I can do that again if you'd like.) Hi Karl, I am interested to have your C program. I searched in the archives but could not find

[GENERAL] Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function

2013-01-02 Thread Ali Pouya
Hi all, The SQL file joined here reproduces the simplified version of a problem that I encounter when trying to use the NEW record in an EXECUTE command within a PL/PgSql trigger function. In this script the commented INSERT command works fine but the EXECUTE commande returns the following error

Re: [GENERAL] Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function

2013-01-02 Thread Ali Pouya
2013/1/2 Pavel Stehule pavel.steh...@gmail.com you forgot USING clause BEGIN EXECUTE 'INSERT INTO measurement1 values(new.*)' USING new; --INSERT INTO measurement1 values(new.*); RETURN NULL; END; Regards Pavel Stehule Hi Pavel, Thanks for your answer, but it