Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Why table has drop, but the foreign key still there?
Date
Msg-id 10660.1060804383@sss.pgh.pa.us
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
Tree view 
Raymond Chui <raymond.chui@noaa.gov> writes:
> drop table whitepage;
> delete from state where state_code = 'GU';
> ERROR:   Relation "whitepage" does not exist

> Why I got this error message??!!

I could not duplicate this error.  What PG version are you running?

            regards, tom lane

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Why table has drop, but the foreign key still there?
Next
From: Rod Taylor
Date:
Subject: Re: Why table has drop, but the foreign key still there?