Re: patch for 9.2: enhanced errors

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: patch for 9.2: enhanced errors
Date: 2011-07-18 21:13:42
Message-ID: 4E245BB6020000250003F48D@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> I'm less concerned about the standard here and more concerned
> about what helps our users. Having column names for an FK error
> is *extremely* useful for troubleshooting, particularly if the
> database has been upgraded from the 7.4 days and has non-useful FK
> names like "$3".

If it gives a FK constraint name, isn't there a way to get from that
to the columns used by the constraint? If we want to support
something non-standard, we can always tell them to look at the text
of the error detail, right?

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-07-18 21:40:58 Re: Commitfest Status: Sudden Death Overtime
Previous Message Josh Berkus 2011-07-18 21:08:43 Re: Commitfest Status: Sudden Death Overtime