Re: PSQL return coder

Hello

2013/10/10 James Sewell <james(dot)sewell(at)lisasoft(dot)com>

> Hello,
>
> I am using PSQL to run SQL from a file with the -f flag as follows:
>
> BEGIN
> SQL
> SQL
> ...
> END
>
> This gives me rollback on error and a nicer output than -1. This works
> fine.
>
> My question is in a rollback scenario is it possible to get PSQL to return
> a non 0 exit status?
>

probably not - from psql perspective all statements was perfect

Pavel

>
> Cheers,a
> James
>
>
>
> --
>
> 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.
>
>