Re: [HACKERS] "stored procedures"

2013-04-16 Thread aasat
Is "stored procedures" planned in future? I think is a "most missing" future today in Postgres. Using a dblink to emulate commit in transaction is very complicated -- View this message in context: http://postgresql.1045698.n5.nabble.com/stored-procedures-tp4331060p5752274.html Sent from the P

Re: [HACKERS] Access Error Details from PL/pgSQL

2012-02-21 Thread aasat
I have question. GET STACKED DIAGNOSTICS work only in exception block? is it posible to use it in separate function called in exception block? EXCEPTION WHEN others THEN peform log_error(); END; CREATE OR REPLACE FUNCTION log_error() RETURNS boolean AS $BODY$ declare v_state TEXT;