On Wed, Oct 11, 2006 at 08:56:23PM +0200, Rafal Pietrak wrote: > Apparently there is also no way to "foreign key reference" those, even > without installing any on-delete actions/triggers. > > Pity. > > Are there any plans for anything like that (referencing keys in system > tables from public schemas)? Not really. The primary objection is that every lookup in the backend on the system catalogs (of which there are many) would have to be modified to check for triggers. This would be bad for performence against a handful of cases where it would be useful. What may have a better chance is assigning triggers to commands (like ON CREATE USER) which trigger on specific situations. No-one serious considered implementing this though, at it's unclear what the use-case would be anyway... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature