[postgres@pgprd01 pgcheck]$ psql --version psql (PostgreSQL) 8.4.2 contains support for command-line editing
[postgres@pgprd01 pgcheck]$ uname -a Linux system.name.com 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
From: compuguruchrisbarnes@hotmail.com To: pgsql-general@postgresql.org Subject: [GENERAL] Postgres wont drop foriegn keys on tables. Date: Thu, 23 Sep 2010 11:01:28 -0400
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
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.