RE: Imperfect solutions

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема RE: Imperfect solutions
Дата
Msg-id ECEHIKNFIMMECLEBJFIGIEOGCAAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на RE: Imperfect solutions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы RE: Imperfect solutions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Idea: quicker abort after loss of client connection
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: RE: Feature request : Remove identifier length constraints