Re: Stop execution without ERROR

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