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 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 &

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

2009-09-24 Thread ning
ostgres STATEMENT: DELETE FROM Printer WHERE PrinterObjId=0; 2009-09-24 13:53:59 JST jmdb postgres ERROR: current 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 "STAR

[HACKERS] memory free of constantly changed function

2009-08-17 Thread ning
s pg_temp.dyn_eval() is dropped. I am using PostgreSQL 8.2.4. Thank you. 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 :