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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alex Hunsaker" <badalex(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Date: 2008-12-30 04:00:18
Message-ID: 9414.1230609618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alex Hunsaker" <badalex(at)gmail(dot)com> writes:
> Namely it does not disable the rule... Enabling inside of the
> transaction seems to work though

Fixed, thanks ...

Index: relcache.c
===================================================================
RCS file: /cvsroot/pgsql/src/backend/utils/cache/relcache.c,v
retrieving revision 1.266.2.4
diff -c -r1.266.2.4 relcache.c
*** relcache.c 10 Aug 2008 19:02:46 -0000 1.266.2.4
--- relcache.c 30 Dec 2008 03:53:15 -0000
***************
*** 770,775 ****
--- 770,777 ----
return false;
if (rule1->attrno != rule2->attrno)
return false;
+ if (rule1->enabled != rule2->enabled)
+ return false;
if (rule1->isInstead != rule2->isInstead)
return false;
if (!equal(rule1->qual, rule2->qual))

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2008-12-30 08:49:07 Re: Bug
Previous Message Alex Hunsaker 2008-12-30 02:43:03 Re: ALTER TABLE DISABLE RULE does not work inside of a transaction