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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
