Re: Get constrrelid for fk constraints that lost it

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Get constrrelid for fk constraints that lost it
Date: 2002-09-30 15:24:20
Message-ID: 21547.1033399460@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
>> (We can tweak the RI triggers to make the runtime failure message be
>> more helpful than "Relation 0 not found".) ISTM the point of having

> Are we mostly concerned about the case where it's 0 or all cases
> where the constrrelid relation doesn't open?

I'd only special-case OID 0; we can reasonably assume that came from
a broken CREATE CONSTRAINT TRIGGER definition. Any other failure is
harder to guess at the cause of, so we should just let the generic
error reporting do its thing.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Stephan Szabo 2002-09-30 16:19:09 Re: Get constrrelid for fk constraints that lost it
Previous Message Stephan Szabo 2002-09-30 15:14:14 Re: Get constrrelid for fk constraints that lost it