Re: Can a table have a reference to itself?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Oliver Duke-Williams <o(dot)duke-williams(at)geog(dot)leeds(dot)ac(dot)uk>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Can a table have a reference to itself?
Date: 2003-07-28 03:47:52
Message-ID: 20030727204704.T30887-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Witham 2003-07-28 03:59:52 Using a compound primary key
Previous Message Roberto Mello 2003-07-28 00:27:54 Re: Very strange 'now' behaviour in nested triggers.