Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Mon, 29 Dec 2008 23:00:18 -0500
  • Message-id: <9414.1230609618@sss.pgh.pa.us> <text/plain>

"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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group