On Tue, 2006-05-09 at 01:20 +0200, Albert Cervera Areny wrote:
> In my particular case (don't know about the SQL standard or other cases),
> it'd be enough if when an inherited table is created:
> - A primary key in the inherited table is created with the same columns as
> the super table.
> - A trigger is created in the new table that ensures that this primary key
> doesn't exist in the super table.
> - A trigger is created in the super table that ensures that this primary key
> doesn't exist in it's sub tables.
Why not add these in your design rather than into the database?
All of the above can be added using existing DDL and you can group
things together in a transaction and call when required.
-- Simon Riggs EnterpriseDB http://www.enterprisedb.com