Thread: Error message

Error message

From
"Chad Thompson"
Date:
I have a 3rd party software that dumps results to my Postgresql database. 
Every so often I get debug information saying ERROR:  Relation "lines" does not exist
Obviously this software is querying for lines, which doesnt exist in my database. 
Is there anyway to find out what query is being submitted to generate this error?
 
TIA
Chad

Re: [May be Spam]Re: Error message

From
"Chad Thompson"
Date:
THANKS!!!

Chad

----- Original Message -----
From: "Oliver Elphick" <olly@lfix.co.uk>
To: "Chad Thompson" <chad@weblinkservices.com>
Sent: Tuesday, October 22, 2002 4:36 PM
Subject: [May be Spam]Re: [NOVICE] Error message


> On Tue, 2002-10-22 at 21:52, Chad Thompson wrote:
> > I have a 3rd party software that dumps results to my Postgresql
database.
> > Every so often I get debug information saying ERROR:  Relation "lines"
does not exist
> > Obviously this software is querying for lines, which doesnt exist in my
database.
> > Is there anyway to find out what query is being submitted to generate
this error?
>
> Set DEBUG_PRINT_QUERY on in postgresql.conf.  This should end queries to
> the log.  The query you want should appear just before the error.
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "But what things were gain to me, those I counted loss
>       for Christ."                 Philippians 3:7
>
>


Re: Error message

From
"Henshall, Stuart - Design & Print"
Date:
IIRC starting postmaster with -d 2 will show queries (may need higher)
hth,
- Stuart
-----Original Message-----
From: Chad Thompson [mailto:chad@weblinkservices.com]
Sent: 22 October 2002 21:53
To: pgsql-novice
Subject: [NOVICE] Error message

I have a 3rd party software that dumps results to my Postgresql database. 
Every so often I get debug information saying ERROR:  Relation "lines" does not exist
Obviously this software is querying for lines, which doesnt exist in my database. 
Is there anyway to find out what query is being submitted to generate this error?
 
TIA
Chad