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

Re: BUG in temp tables involving a temp table not properly

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG in temp tables involving a temp table not properly
Date: 2005-06-07 16:37:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

SS> You've analyzed the situation incorrectly I believe.
SS> In this query in the subselect the id column is an outer reference to 
SS> the id column generated from full_sequence.

TL> This is not a bug, it is user error.
TL> The actual problem here is that "id" is a perfectly valid outer reference

You're right, now why didn't I see that myself.... ;)

Sorry to have bothered you guys / the list!


an Oost 102-008
5013 CD  Tilburg
Tel: (+31).13.5425551, Fax: (+31).13.5452087
Would you buy a car with the hood welded shut? (Linux, the maintainable OS)
This is Unix Country. On a quiet night you can hear NT reboot.
De in dit emailbericht verstrekte informatie is vertrouwelijk en uitsluiten=
bestemd voor de geadresseerde. Het kopi=EBren van of verstrekken aan en geb=
door derden van deze informatie is niet toegestaan. Door de elektronische=20
verzending van dit bericht kunnen er geen rechten worden ontleend aan de=20
This email and any files transmitted with it are confidential and intended=
solely for the use of the individual or entity to whom they are addressed.
Copyright (c) 2005 Foxi C.i.T. BV All world wide rights reserved.

In response to

pgsql-bugs by date

Next:From: Josh BerkusDate: 2005-06-07 23:16:49
Subject: pg_ctl inappropriately timing out?
Previous:From: Tom LaneDate: 2005-06-07 16:32:46
Subject: Re: BUG in temp tables involving a temp table not properly hiding a regular table as well as allowing non-existent column names

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