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: 40ADB9B8.3000600@archonet.com (view raw or flat)
Thread:
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-2014 The PostgreSQL Global Development Group