Search Postgresql Archives

Re: STABLE functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux