RE: Imperfect solutions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject RE: Imperfect solutions
Date
Msg-id ECEHIKNFIMMECLEBJFIGIEOGCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to RE: Imperfect solutions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses RE: Imperfect solutions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
> > Those two points are already mentioned - I have another 90%
> patch ready to
> > go that will add that functionality as well...
>
> As a question, are you doing anything to handle dropping referenced unique
> constraints or are we just waiting on that until a referencing system
> is built?

By that do you mean: what happens when you drop a primary key that is
referenced by a foreign key?

My answer: Forgot about that ;)  I'll see what I can do but anytime
investigation of foreign keys is required it's a real pain.  Foreign keys
are kinda next on my list for work, so I might look at it then if it's too
difficult right now.  (I've got a query that can find all foreign keys on a
relation, and what they relate to, that I'm going to add to psql).

My other questions then are:

Does anything else (other than fk's) ever reference a primary key?
What can reference a unique key?

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Idea: quicker abort after loss of client connection
Next
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Feature request : Remove identifier length constraints