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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to