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 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
