Re: Dropped table screws referential integrity?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Dropped table screws referential integrity?
Дата
Msg-id 20020307085622.Y77313-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Dropped table screws referential integrity?  (Joel Mc Graw <jmcgraw@databill.com>)
Ответы Re: Dropped table screws referential integrity?
Список pgsql-admin
On Thu, 7 Mar 2002, Joel Mc Graw wrote:

> I had a table (job_documents) that referenced another (jobs).  I no
> longer needed job_documents, so I dropped it.  Now, any attempt to
> delete rows from jobs fails--it complains that job_documents doesn't
> exist.  Is there a way to fix this?

You'll need to find the two triggers on jobs that reference job_documents
(do a select * from pg_trigger and look at the argument list to find
them) and drop them and you should be fine.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Joel Mc Graw
Дата:
Сообщение: Dropped table screws referential integrity?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] PGSTAT Error from Postmaster