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

pgsql-server/src/backend optimizer/plan/initsp ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src/backend optimizer/plan/initsp ...
Date: 2003-11-05 22:00:46
Message-ID: 20031105220046.D0384D1BB8B@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)svr1(dot)postgresql(dot)org	03/11/05 18:00:46

Modified files:
	src/backend/optimizer/plan: initsplan.c 
	src/backend/parser: analyze.c 

Log message:
	Fix for this problem:
	
	regression=# select 1 from tenk1 ta cross join tenk1 tb for update;
	ERROR:  no relation entry for relid 3
	
	7.3 said "SELECT FOR UPDATE cannot be applied to a join", which was better
	but still wrong, considering that 7.2 took the query just fine.  Fix by
	making transformForUpdate() ignore JOIN and other special RTE types,
	rather than trying to mark them FOR UPDATE.  The actual error message now
	only appears if you explicitly name the join in FOR UPDATE.


pgsql-committers by date

Next:From: Tom LaneDate: 2003-11-05 22:00:52
Subject: pgsql-server/src/backend optimizer/plan/Tag: o ...
Previous:From: Robert TreatDate: 2003-11-05 17:16:36
Subject: Re: pgsql-server/src/interfaces/jdbc build.xml org ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group