Postgres wont drop foriegn keys on tables.

Поиск
Список
Период
Сортировка
От Chris Barnes
Тема Postgres wont drop foriegn keys on tables.
Дата
Msg-id BLU149-W409ADC3693D8FFD8214627D4610@phx.gbl
обсуждение исходный текст
Ответы Re: Postgres wont drop foriegn keys on tables.  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Re: Postgres wont drop foriegn keys on tables.  (Vick Khera <vivek@khera.org>)
Re: Postgres wont drop foriegn keys on tables.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I am having an odd problem that I have seen before. It usually clears itself after I restart postgres.

I am attempting to drop an foreign key on a table and it sits for hours and doesn't drop or put anything into the log.

Killing the alter puts an error in, but it doesn't time out and it cause the system to lock at some point.

What can I do to troubleshoot this?

Chris


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Feature request: pgcron
Следующее
От: Chris Barnes
Дата:
Сообщение: Re: Postgres wont drop foriegn keys on tables.