On Mon, Aug 09, 2004 at 11:56:17AM +1000, fastpgs wrote:
> On Sun, 8 Aug 2004 08:19, Alvaro Herrera wrote:
>
> > If the change is global, what should happen on other sessions that have
> > a deferred event from that trigger concurrently with the one that
> > modifies it? Should the answer be diff
On Sun, 8 Aug 2004 08:19, Alvaro Herrera wrote:
> If the change is global, what should happen on other sessions that have
> a deferred event from that trigger concurrently with the one that
> modifies it? Should the answer be different depending on the isolation
> mode of the transaction?
This w
On Fri, Aug 06, 2004 at 03:14:13PM +1000, fastpgs wrote:
> And finally about the scope of the change of status of a trigger.
> Should this be local to the session or should be reflected globally?
> My humble opinion is it should be reflected globally(again, as in
> oracle ?)
If the change is
Hi All,
I would like to implement the 'DISABLE TRIGGER' functionality for
Postgres...
My proposal for a syntax are the following. We could choose either or
all of the following
a) ALTER TABLE DISABLE|ENABLE ALL TRIGGERS
(This syntax is available in oracle to alter all triggers for any g
