Andreas-3-2 wrote > I never placed a bug-report. :} > Could you give a hand? Sure. PostgreSQL homepage (postgresql.org) "Report a Bug" link on right-hand side of page. Fill in the form. >>>SEND THIS>>>> > drop table if exists sub_tab; > drop table if exists main_tab; > drop table if exists flag_1; > drop table if exists flag_2; > > create temporary table flag_1 ( flag_1_id integer primary key, flag_1_t > text ); > insert into flag_1 values (0, null ), ( 1, 'a' ), ( 2, 'b' ), ( 3, 'c' ); > > create temporary table flag_2 ( flag_2_id integer primary key, flag_2_t > text ); > insert into flag_2 values (0, null ), ( 1, 'a' ), ( 2, 'b' ), ( 3, 'c' ); > > create temporary table main_tab ( main_id integer primary key, main_t > text, flag_1_id integer references flag_1 ( flag_1_id ) ); > insert into main_tab values ( 1, 'Main 1', 1 ), ( 2, 'Main 2', 2 ), ( 3, > 'Main 3', 3 ); > > create temporary table sub_tab ( sub_id integer primary key, sub_t > text, main_id integer references main_tab ( main_id ), flag_1_id integer > references flag_1 ( flag_1_id ), flag_2_id integer references flag_2 ( > flag_2_id ) ); > insert into sub_tab values ( 1, 'Sub 1', 1, 3, 1 ), ( 2, 'Sub 2', 2, 2, > 2 ), ( 3, 'Sub 3', 3, 1, 3 ); > > > select m.main_id, m.main_t, f.flag_1_t, > x.sub_id, x.sub_t, x.flag_1_t, x.flag_2_t > from main_tab as m > join flag_1 as f using ( flag_1_id ) > left join > ( > sub_tab as s > join flag_2 as f2 using ( flag_2_id ) -- that > way it works > join flag_1 as f using ( flag_1_id ) > -- join flag_2 as f2 using ( flag_2_id ) -- that > way it doesn't work > ) as x using ( main_id ); -- 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-tp5770489p5770534.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
