Re: Postgresql error from interface

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql error from interface
Date: 2010-03-22 17:45:20
Message-ID: 9712.1269279920@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bob Pawley" <rjpawley(at)shaw(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Barnes 2010-03-22 17:55:36 Re: Create a function that updates the record with and timestamps
Previous Message Bob Pawley 2010-03-22 17:39:07 Postgresql error from interface