Thread: Postgresql error from interface

Postgresql error from interface

From
"Bob Pawley"
Date:
Hi
 
I have an interface (Delphi) for my Postgresql database, that is telling me that I have an inconsistancy between one of the Postgresql triggers and a Postgresql table. The problem for me is - the message doesn't give me enough information to determine which trigger has the error.
 
Is there some way of doing an overall search without having to search each trigger individually??
 
Bob

Re: Postgresql error from interface

From
Tom Lane
Date:
"Bob Pawley" <rjpawley@shaw.ca> writes:
> I have an interface (Delphi) for my Postgresql database, that is telling me that I have an inconsistancy between one
ofthe Postgresql triggers and a Postgresql table. The problem for me is - the message doesn't give me enough
informationto determine which trigger has the error. 

> Is there some way of doing an overall search without having to search each trigger individually??

You could try looking in the postmaster log to see if there's any more
information in the underlying Postgres error message(s).

            regards, tom lane