Skip site navigation (1) Skip section navigation (2)

Re: v7.2 triggers and foreign keys

From: Richard Huxton <dev(at)archonet(dot)com>
To: Paul Gimpelj <pgimpelj(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: v7.2 triggers and foreign keys
Date: 2004-05-21 08:11:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Paul Gimpelj wrote:
> Hi,
> I have two tables a and b.; b references a.
> I used pgaccess to create tables.
> and psql to create the triggers and foreign keys. a has sequential id, and primary key same column.
> As constraints they were implicit, and cascade was off.
> On delete of the of a b row, postgres also deleted the a table row.

You'll need to show the table definitions (with foreign keys etc) and 
also trigger definitions (use "\d table_a" in psql or "pg_dump 
--schema-only -t tablename")

   Richard Huxton
   Archonet Ltd

In response to

pgsql-sql by date

Next:From: Achilleus MantziosDate: 2004-05-21 08:30:35
Subject: Re: Preventing Deletions with triggers
Previous:From: Charlie ClarkDate: 2004-05-21 07:28:34
Subject: Problem with JOINS

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group