Paul Gimpelj wrote:
> 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")
In response to
pgsql-sql by date
|Next:||From: Achilleus Mantzios||Date: 2004-05-21 08:30:35|
|Subject: Re: Preventing Deletions with triggers|
|Previous:||From: Charlie Clark||Date: 2004-05-21 07:28:34|
|Subject: Problem with JOINS|