Postgres Pro
Downloads
Home   >   mailing lists

Re: Get constrrelid for fk constraints that lost it - Mailing list pgsql-patches

From Tom Lane
Subject Re: Get constrrelid for fk constraints that lost it
Date
Msg-id 20994.1033396076@sss.pgh.pa.us
Whole thread Raw
In response to Get constrrelid for fk constraints that lost it  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Get constrrelid for fk constraints that lost it  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-patches
Tree view 
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> ... If the table doesn't exist or there
> aren't enough args to intuit a table name, it currently
> elog errors.  Is that reasonable behavior, or should
> it be taking the constraint and letting it fail at
> runtime?

I was inclined to think it should take the constraint and let the
failure occur at runtime.  A NOTICE would be okay but not an ERROR.
(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
this hack is to allow old dump files to be loaded, and an ERROR would
get in the way of that.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: AIX compilation problems (was Re: [HACKERS] Proposal ...)
Next
From: Stephan Szabo
Date:
Subject: Re: Get constrrelid for fk constraints that lost it