From: Paul Gimpelj <pgimpelj@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: v7.2 triggers and foreign keys
Date: Thu, 20 May 2004 14:32:49 -0400
Message-ID: <004801c43e98$db450060$3410fea9@zoom> (raw)
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.
I then created a2 and b2 with action queries. and the delete acted as expected.
Where am i going wrong with this?
Do I need to install 7.4?
Also, created tables a3 and b3, with sequential ids using pgaccess same as a and b, and the seq id's don't increment with these tables.
Thanks.
paul
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgimpelj@sympatico.ca
Subject: Re: v7.2 triggers and foreign keys
In-Reply-To: <004801c43e98$db450060$3410fea9@zoom>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox