Thread: 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.
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
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 > >
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 messageI 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?TIAChad