| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: STABLE functions |
| Date: | 2006-10-12 09:47:16 |
| Message-ID: | 20061012094716.GB11723@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey E. Koposov | 2006-10-12 09:55:27 | Re: user defined aggregate with multiple arguments |
| Previous Message | Peter | 2006-10-12 09:18:48 | Override system-defined cast? |