Thanks Igor, this is a sufficient idea to take into account for upgrading to 9.x release. Thanks again.
Roberto ----- Messaggio originale ----- Da: "Igor Neyman" <[email protected]> A: "Roberto Grandi" <[email protected]>, [email protected] Inviato: Mercoledì, 18 settembre 2013 15:37:12 Oggetto: RE: Catch exceptions outside function > -----Original Message----- > From: [email protected] [mailto:pgsql-admin- > [email protected]] On Behalf Of Roberto Grandi > Sent: Wednesday, September 18, 2013 6:17 AM > To: [email protected] > Subject: [ADMIN] Catch exceptions outside function > > > Dear all > > I ask for your help cause I can't point out the solution to my problem on PG > 8.3 I would catch an exception outside any function/procedure but directly > within script. > > > BEGIN; > > -- raise an exception code > > EXCEPTION > WHEN 'exception_type' > THEN ROLLBACK; > > COMMIT; > > is it possible with PG 8.3? > > > Many thanks in advance. > > Roberto > No. It's not possible in 8.3. What you want is basically anonymous plpgsql block, "EXCEPTION" - is plpgsql, not pure sql, could be used only inside plpgsql function in 8.3. OTOH, starting with 9.0 you can use anonymous plpgsql blocks, and get what you asked for. Regards, Igor Neyman -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
