Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EC3D7475FBE for ; Tue, 19 Nov 2002 18:15:37 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 08904475F3D for ; Tue, 19 Nov 2002 18:15:35 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id gAJNFUhR026638; Tue, 19 Nov 2002 18:15:31 -0500 (EST) To: Stephan Szabo Cc: Chris Gamache , pgsql-sql@postgresql.org Subject: Re: Using VIEW to simplify code... In-reply-to: <20021119145457.Y71165-100000@megazone23.bigpanda.com> References: <20021119145457.Y71165-100000@megazone23.bigpanda.com> Comments: In-reply-to Stephan Szabo message dated "Tue, 19 Nov 2002 14:56:50 -0800" Date: Tue, 19 Nov 2002 18:15:30 -0500 Message-ID: <26637.1037747730@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/288 X-Sequence-Number: 10430 Stephan Szabo writes: > On Tue, 19 Nov 2002, Chris Gamache wrote: >> Understood. PostgreSQL 7.2.3. > 7.3 will be better for this. There were questions about the safety > of pushing clauses down in queries with union and intersect and > earlier versions wouldn't push down because we weren't sure it was > safe. Except will still be problematic, but union and intersect should be > much happier. Yeah, the UNIONs in the view are definitely the big problem. Can you try on 7.3rc1 and see how it goes? regards, tom lane