Postgres Pro
Downloads
Home   >   mailing lists

Postgres wont drop foriegn keys on tables. - Mailing list pgsql-general

From Chris Barnes
Subject Postgres wont drop foriegn keys on tables.
Date
Msg-id BLU149-W409ADC3693D8FFD8214627D4610@phx.gbl
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Feature request: pgcron
Next
From: Chris Barnes
Date:
Subject: Re: Postgres wont drop foriegn keys on tables.