Re: How to get last Error Message/Code

On 08/03/11 10:03 PM, Earth Analizer wrote:
> Hi,
>
> I am new to Postgres and I would like to know how I can get the last
> error message.
> I am using a programming language called "Paradox" and, when an error
> occurs,
> it converts the Postgres error code to its own error code.
> Sometimes Paradox displays a funny message, if it does not recognize
> the code and
> the error message it displays gives me no clue for what actually happened.
>
> if anyone knows the solution, please let me know.
>
> Thank you in advance.
> Cheers!

any SQL errors should be in postgres' logfile, which typically is
accessible only to the postgres user, in the pg data/pg_log directory

I usually like to make a few tweaks to the logging defaults, like

log_line_prefix = '%m %u(at)%d[%p]:'

which will timestamp the logs, and give you user(at)database[pid]: in front
of each entry, like...

2011-08-04 02:06:46.681 PDT postgres(at)postgres[12927]:ERROR: column
"junk" does not exist at character 8
2011-08-04 02:06:46.681 PDT postgres(at)postgres[12927]:STATEMENT: select
junk;

--
john r pierce N 37, W 122
santa cruz ca mid-left coast