Postgresql error from interface

Started by Bob Pawleyabout 16 years ago2 messagesgeneral
Jump to latest
#1Bob Pawley
rjpawley@shaw.ca

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bob Pawley (#1)
Re: Postgresql error from interface

"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 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??

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