[BUGS] Re: BUG #8444: ERROR: table name "tblb" specified more than once in subquery

2013-09-13 Thread David Johnston
Tom Lane-2 wrote > David Johnston < > polobo@ > > writes: >>> Here is a minimal query that demonstrates the problem. In 9.1 it works: >>> >>> chris=# select * FROM current_user u join (current_user u cross join >>> current_user v) x on true; >>> >>> On 9.3 it fails: >>> ERROR: table name "u"

Re: [BUGS] Re: BUG #8444: ERROR: table name "tblb" specified more than once in subquery

2013-09-13 Thread Tom Lane
David Johnston writes: >> Here is a minimal query that demonstrates the problem. In 9.1 it works: >> >> chris=# select * FROM current_user u join (current_user u cross join >> current_user v) x on true; >> >> On 9.3 it fails: >> ERROR: table name "u" specified more than once This is an intent

[BUGS] Re: BUG #8444: ERROR: table name "tblb" specified more than once in subquery

2013-09-12 Thread David Johnston
A much more simple example courtesy of Chris Travers from the original -general thread that I suggested be moved to -bugs. > Here is a minimal query that demonstrates the problem. In 9.1 it works: > > chris=# select * FROM current_user u join (current_user u cross join > current_user v) x on tr