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.
Re: Postgres wont drop foriegn keys on tables.
Re: Postgres wont drop foriegn keys on tables.
List 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 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.