Postgres Pro
Downloads
Home   >   mailing lists

Thread: Stop execution without ERROR

Stop execution without ERROR

From
James Sewell
Date:
Hello all,

Let's say I'm running the following SQL script via psql -f

BEGIN
\set ON_ERROR_STOP
SELECT myFunction();
CREATE TABLE x(id int);
END;

Is there anything I can do in myFunction which will:

a) Stop execution of the script so that x will not be created
b) Not throw an error (return value of 0, no ERROR in output)

I am currently using an EXCEPTION, which satisfies a, but not b.

Cheers,

James Sewell,
PostgreSQL Team Lead / Solutions Architect
______________________________________
 

Level 2, 50 Queen St, Melbourne VIC 3000

P (+61) 3 8370 8000  W www.lisasoft.com  F (+61) 3 8370 8099
 

The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.

Re: Stop execution without ERROR

From
David Johnston
Date:
james.sewell wrote
> Hello all,
>
> Let's say I'm running the following SQL script via psql -f
>
> BEGIN
> \set ON_ERROR_STOP
> SELECT myFunction();
> CREATE TABLE x(id int);
> END;
>
> Is there anything I can do in myFunction which will:
>
> a) Stop execution of the script so that x will not be created
> b) Not throw an error (return value of 0, no ERROR in output)
>
> I am currently using an EXCEPTION, which satisfies a, but not b.

No.  To accomplish that kind of flow control requires that you use a
procedural language.  pl/pgsql can serve that purpose.  You can use a
function or a DO block to implement.  Or code a shell script.

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Stop-execution-without-ERROR-tp5774688p5774689.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Stop execution without ERROR

From
Karsten Hilbert
Date:
On Wed, Oct 16, 2013 at 12:04:53PM +1100, James Sewell wrote:

> Let's say I'm running the following SQL script via psql -f
>
> BEGIN
> \set ON_ERROR_STOP
> SELECT myFunction();
> CREATE TABLE x(id int);
> END;
>
> Is there anything I can do in myFunction which will:
>
> a) Stop execution of the script so that x will not be created
> b) Not throw an error (return value of 0, no ERROR in output)
>
> I am currently using an EXCEPTION, which satisfies a, but not b.

Any reason you aren't conditionally CREATEing TABLE inside myFunction() ?

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346