Unix Technical Forum

pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

This is a discussion on pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it within the pgsql Committers forums, part of the PostgreSQL category; --> Log Message: ----------- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Committers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-10-2008, 02:05 PM
Tom Lane
 
Posts: n/a
Default pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

Log Message:
-----------
Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update
varoattno along with varattno. This resulted in having Vars that were not
seen as equal(), causing inheritance of the "same" constraint from different
parent relations to fail. An example is

create table pp1 (f1 int check (f1>0));
create table cc1 (f2 text, f3 int) inherits (pp1);
create table cc2(f4 float) inherits(pp1,cc1);

Backpatch as far as 7.4. (The test case still fails in 7.4, for reasons
that I don't feel like investigating at the moment.)

This is a backpatch commit only. The fix will be applied in HEAD as part
of the upcoming pg_constraint patch.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
pgsql/src/backend/commands:
tablecmds.c (r1.206.2.4 -> r1.206.2.5)
(http://anoncvs.postgresql.org/cvsweb...4&r2=1.206.2.5)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:36 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com