X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 4348BD1C935; Wed, 13 Aug 2003 19:54:29 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024)
	with ESMTP id 63044-07; Wed, 13 Aug 2003 16:52:53 -0300 (ADT)
Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 7EF39D1C4E1; Wed, 13 Aug 2003 16:54:18 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id 90B9D1024D; Wed, 13 Aug 2003 15:46:46 -0400 (EDT)
Received: from [10.0.2.6] (unknown [10.0.2.6])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id B73BF10248; Wed, 13 Aug 2003 15:46:44 -0400 (EDT)
Subject: Re: Why table has drop, but the foreign key still there?
From: Rod Taylor <rbt@rbt.ca>
To: Raymond Chui <raymond.chui@noaa.gov>
Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org,
	pgsql-sql@postgresql.org
In-Reply-To: <3F3A8010.9030701@noaa.gov>
References: <3F3A8010.9030701@noaa.gov>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-0klTIuJXeZCwCWErrput"
Message-Id: <1060804459.11688.80.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Wed, 13 Aug 2003 15:54:19 -0400
X-Virus-Scanned: by AMaViS perl-11
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/164
X-Sequence-Number: 9886

--=-0klTIuJXeZCwCWErrput
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> insert into state (state_code,state) values ('GU','Guam');
> drop table whitepage;
> delete from state where state_code =3D '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.

--=-0klTIuJXeZCwCWErrput
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/Opdq6DETLow6vwwRAvMNAJ9Bqq3izCph/npf+z1e52k/QK+bmgCfS7CU
zijt6Ua+ScfZIVRP/7YA+2I=
=Enpi
-----END PGP SIGNATURE-----

--=-0klTIuJXeZCwCWErrput--