Обсуждение: Postgresql error from interface

Поиск
Список
Период
Сортировка

Postgresql error from interface

От
"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

Re: Postgresql error from interface

От
Tom Lane
Дата:
"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