Home > mailing lists

Re: Can a table have a reference to itself? - Mailing list pgsql-sql

From	Stephan Szabo
Subject	Re: Can a table have a reference to itself?
Date	July 28, 2003 00:48:03
Msg-id	20030727204704.T30887-100000@megazone.bigpanda.com Whole thread Raw
In response to	Can a table have a reference to itself? (Oliver Duke-Williams <o.duke-williams@geog.leeds.ac.uk>)
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Jonathan Bartlett
Date: 27 July 2003, 23:35:38
Subject: Function index qeustion

From: "David Witham"
Date: 28 July 2003, 01:00:13
Subject: Using a compound primary key

Re: Can a table have a reference to itself? - Mailing list pgsql-sql

Previous

Next