X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 37655D1C4D5 for ; Mon, 28 Jul 2003 03:48:00 +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 58501-08 for ; Mon, 28 Jul 2003 00:47:01 -0300 (ADT) Received: from megazone.bigpanda.com (unknown [66.180.233.26]) by svr1.postgresql.org (Postfix) with ESMTP id 3589ED1C4BB for ; Mon, 28 Jul 2003 00:47:55 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B8FA1D6B1; Sun, 27 Jul 2003 20:47:52 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 9E7155C0F; Sun, 27 Jul 2003 20:47:52 -0700 (PDT) Date: Sun, 27 Jul 2003 20:47:52 -0700 (PDT) From: Stephan Szabo To: Oliver Duke-Williams Cc: Subject: Re: Can a table have a reference to itself? In-Reply-To: <3F1E9F6E.2090600@geog.leeds.ac.uk> Message-ID: <20030727204704.T30887-100000@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/409 X-Sequence-Number: 14523 On Wed, 23 Jul 2003, Oliver Duke-Williams wrote: > I'd like to have a table in which one column has an integrity reference > to another column within the same table, and for updates to the primary > column to be cascaded. The former aspect seems to work OK, but the > latter does not. I think you need to upgrade to 7.3 or better and try it there. I think that's when those bugs were fixed.