Skip site navigation (1) Skip section navigation (2)

Get constrrelid for fk constraints that lost it

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Get constrrelid for fk constraints that lost it
Date: 2002-09-30 05:01:34
Message-ID: 20020929213738.N75495-200000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-patches
I believe this should allow create constraint trigger
to look up the constrrelid out of the fk constraint
arguments for those cases where the FROM clause
was lost if we want to go that route.


It determines if it should look up args and which
argument to use based on the function name and won't
probably handle delimited names nicely. I figured
that since the point of it is to read old dumps,
this is okay.  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?

Attachment: constrrelid.patch
Description: text/plain (1.9 KB)

Responses

pgsql-patches by date

Next:From: Zeugswetter Andreas SB SDDate: 2002-09-30 11:59:54
Subject: AIX compilation problems (was Re: Proposal ...)
Previous:From: Tom LaneDate: 2002-09-30 03:48:18
Subject: Re: DROP COLUMN misbehaviour with multiple inheritance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group