Re: Fwd: Psql.exe error logging - Mailing list pgsql-www

From Melvin Davidson
Subject Re: Fwd: Psql.exe error logging
Date
Msg-id CANu8FixA=Y8JnxnSw0+P3SZKryQjta3PeNsoKmQ0OwQqN+SUSA@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Psql.exe error logging  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Fwd: Psql.exe error logging
List pgsql-www


On Fri, Feb 26, 2016 at 10:21 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Feb 26, 2016 at 7:36 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Feb 26, 2016 at 4:29 AM, Aman Rathi <aman.rathi0904@gmail.com> wrote:
Hi David,

Thanks for the reply, but it still doesn't seem to run.

I followed the following steps:
1) updated the on_error_stop value to 1

Inline image 1

2) Ran a command that should fail and exit

Inline image 1


​Any particular reason you didn't just add the --set option from #1 to the psql command in #2?



​As an aside, the portion of the command "psql -c -a -f <file>" is wrong (though apparently not broken...).  You specify, via "c", that you are going to provide a single command for psql to execute but then fail to provide any such command and instead change you mind and tell it your are going to provide a script file, via "f", instead.

David J.​

>3) Checked my java log and it shows it ran without errors and continued with the program.

Do you realize that all psql errors will go to the postgresql log file, not java log?

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Attachment

pgsql-www by date:

Previous
From: Aman Rathi
Date:
Subject: Re: Fwd: Psql.exe error logging
Next
From: "David G. Johnston"
Date:
Subject: Re: Fwd: Psql.exe error logging