[HACKERS] BEGIN TRANSACTION and START TRANSACTION: different error handling

2009-09-24 Thread ning
transaction is aborted, commands ignored until end of transaction block - I searched archives, but no related comment is found. Should I do some setting on server to make the START TRANSACTION act as BEGIN TRANSACTION? Thank you. Greetings, Ning Xie -- Sent via pgsql-hackers mailing list

Re: [HACKERS] BEGIN TRANSACTION and START TRANSACTION: different error handling

2009-09-24 Thread ning
On Thu, Sep 24, 2009 at 6:16 PM, Hannu Krosing ha...@krosing.net wrote: On Thu, 2009-09-24 at 17:51 +0900, ning wrote: Hi all, I am using psqlodbc to connect to PostgreSQL8.2.4 server on Linux. The manual says BEGIN TRANSACATION is equlvalent to START TRANSACTION, but it turns out

[HACKERS] memory free of constantly changed function

2009-08-17 Thread ning
. ning - CREATE FUNCTION function_factory(t1 TEXT, t2 TEXT, t3 TEXT) RETURNS VOID AS $$ DECLARE func_body TEXT; func_cmd TEXT; BEGIN func_body := 'DECLARE '; func_body := func_body || t2; func_body := func_body || 'BEGIN '; func_body := func_body || t3; func_body := func_body