Andreas-3-2 wrote > No, it doesn't work in psql of PG 9.3. I got from EnterpriseDB Can you please create a minimal self-contained query that exhibits this behavior and file a bug report? I quickly cobbled this together - works on 9.0.x WITH tblA (a_id, a_val) AS ( VALUES (1::integer, 'one-a'::varchar) ) , tblB (b_id, b_val) AS ( VALUES (1::integer, 'one-b'::varchar) ) , tblC (c_id, c_val) AS ( VALUES (1::integer, 'one-c'::varchar) ) SELECT * FROM ( tblA AS dup_tbl JOIN tblB ON (dup_tbl.a_id = tblB.b_id) ) AS refD JOIN tblC AS dup_tbl ON (dup_tbl.c_id = refD.a_id) If it fails on 9.3 it would do. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PG-9-3-complains-about-specified-more-than-once-Those-views-worked-in-PG-9-1-9-2-tp5770489p5770519.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
