Re: STABLE functions - Mailing list pgsql-general

From Rafal Pietrak
Subject Re: STABLE functions
Date
Msg-id 1160649489.4482.223.camel@zorro.isa-geek.com
Whole thread Raw
In response to Re: STABLE functions  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: STABLE functions  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Thu, 2006-10-12 at 11:47 +0200, Martijn van Oosterhout wrote:
> 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...

I see.

From MHO, the use-case would come from the same need, that made me rise
the questions. Namely: need to extend 'user' definition by application
speciffic 'things'.

My particular need was to have the ability to block the account until
its password is changed. Which I believe might (at certain point) come
into the main sources. But other applicatoins may have unforseen
requirements - It would be desirable to allow for those, event to see
just what those applications actually need.

Still. It certeinly does not justyfy entering performance panelties for
every Postgres DB aplication out there.

And yet, may be there are workarounds? Like allowing application
extentions on session SET-able variables? With troggers on update?

--
-R

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: ISO week dates
Next
From: Heikki Linnakangas
Date:
Subject: Re: [PATCHES] ISO week dates