Re: ALTER TABLE DISABLE RULE does not work inside of a transaction

From: "Alex Hunsaker" <badalex(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Date: 2008-12-30 02:43:03
Message-ID: 34d269d40812291843h131feef6v5ce73c2a1b695497@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Dec 29, 2008 at 15:07, Alex Hunsaker <badalex(at)gmail(dot)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!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-12-30 04:00:18 Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Previous Message Alex Hunsaker 2008-12-29 22:07:25 ALTER TABLE DISABLE RULE does not work inside of a transaction