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.