Re: [GENERAL] Postgresql error from interface

2010-03-22 Thread Tom Lane
"Bob Pawley"  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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Postgresql error from interface

2010-03-22 Thread Bob Pawley
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