Re: [SQL] v7.2 triggers and foreign keys

2004-05-21 Thread Richard Huxton
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 al

[SQL] v7.2 triggers and foreign keys

2004-05-20 Thread Paul Gimpelj
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 delete