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

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 true;
>    u   |   u   |   v
> -------+-------+-------
>  chris | chris | chris
> (1 row)
>
> On 9.3 it fails:
> ERROR:  table name "u" specified more than once
>
> It may be a silly example but it works.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8444-ERROR-table-name-tblb-specified-more-than-once-in-subquery-tp5770540p5770654.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.