Re: Outer joins in views
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: mucher@tigana.pl, pgsql-bugs@postgresql.org
Date: 2000-12-04T20:10:13Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.org writes: > In the 7.1 devel version, the OUTER JOIN statementes are working, but > not in VIEWs. I have created the below listed view, and while it > allows to be created, any attempt of using it ends with: > ERROR: Internal error: no jointree entry for rel *OLD* Thanks for the report. However, I can't easily reproduce it with just the CREATE VIEW command. Could I have CREATE TABLE statements for the referenced tables, too, please? regards, tom lane