Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE DISABLE RULE does not work inside of a transaction - Mailing list pgsql-bugs

From Alex Hunsaker
Subject Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Date
Msg-id 34d269d40812291843h131feef6v5ce73c2a1b695497@mail.gmail.com
Whole thread Raw
In response to ALTER TABLE DISABLE RULE does not work inside of a transaction  ("Alex Hunsaker" <badalex@gmail.com>)
List pgsql-bugs
Tree view 
On Mon, Dec 29, 2008 at 15:07, Alex Hunsaker <badalex@gmail.com> wrote:
> Namely it does not disable the rule...

> Enabling inside of the transaction seems to work though

Hrm the above turned out to be false... must have gotten confused when
testing with triggers

If i turn on RELCACHE_FORCE_RELEASE or CLOBBER_CACHE_ALWAYS then it
works as expected.   Maybe this will make someone who understands the
relcache stuff better go Ahh ha!

pgsql-bugs by date:

Previous
From: "Alex Hunsaker"
Date:
Subject: ALTER TABLE DISABLE RULE does not work inside of a transaction
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE DISABLE RULE does not work inside of a transaction