RE: Imperfect solutions

On Wed, 6 Jun 2001, Christopher Kings-Lynne wrote:

> > > 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).

I wouldn't worry all that much about it since you could still break it
with drop index, but I wanted to know if you'd done anything with it
and if so how general it was.

How'd you do the splitting of the arguments to get the columns referenced?
That was the biggest problem I was having, trying to get the bytea split
up. (Well, without writing a function to do it for me)

> My other questions then are:
>
> Does anything else (other than fk's) ever reference a primary key?
> What can reference a unique key?

Foreign keys are the only one I know of, but they can reference either.