> -----Original Message-----
> From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
> Sent: 24 June 2002 16:15
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] foreign Key problem
>
> As a side note, if you're willing to do a few extra inserts,
> there are some workarounds for the foreign key case involving
> another table where you get ids from there and reference that
> table from each of the tables in the hierarchy and tables
> that want to reference the hierarchy reference that table.
>
Hmm, the major reason for wanting the foreign key is maintain integrity
between sys_users & dms_acl. It'll probably be easiest for me to just
remove that foreign key and ensure the app deletes matching acl records
when a particular user is deleted. At least then I can just add the fkey
when/if PostgreSQL gets fixed and won't have a mess of a design left
over from a workaround.
Thanks anyway,
Dave.