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

Paul Gimpelj wrote:
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 majordomo (AT) postgresql (DOT) org)