Re: Why table has drop, but the foreign key still there? - Mailing list pgsql-admin

From Rod Taylor
Subject Re: Why table has drop, but the foreign key still there?
Date
Msg-id 1060804459.11688.80.camel@jester
Whole thread Raw
In response to Why table has drop, but the foreign key still there?  (Raymond Chui <raymond.chui@noaa.gov>)
List pgsql-admin
> insert into state (state_code,state) values ('GU','Guam');
> drop table whitepage;
> delete from state where state_code = 'GU';
> ERROR:   Relation "whitepage" does not exist

Old version of PostgreSQL?  Effort went into cleaning up inter-object
dependencies in 7.3.  I don't recall having that particular issue in
versions prior either.

That said, you can remove the triggers that are on table "state"
beginning with the characters "RI".  psql -d state will tell you what
they are.

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why table has drop, but the foreign key still there?
Next
From: Murthy Kambhampaty
Date:
Subject: Re: Backup procedure