Received: from serv1.ilse.nl (serv1.ilse.nl [212.189.131.11]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2PHESw35392 for ; Sun, 25 Mar 2001 12:14:29 -0500 (EST) (envelope-from mathijs@serv0.ilse.nl) Received: from serv0.ilse.nl (intra.ilse.nl [10.1.8.249]) by serv1.ilse.nl (8.11.0/8.10.2) with ESMTP id f2PHERX16633; Sun, 25 Mar 2001 19:14:27 +0200 (MEST) Received: (from mathijs@localhost) by serv0.ilse.nl (8.11.1/8.11.1) id f2PHEOK60325; Sun, 25 Mar 2001 19:14:24 +0200 (CEST) (envelope-from mathijs) Date: Sun, 25 Mar 2001 19:14:24 +0200 From: Mathijs Brands To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: all views in database broken at once Message-ID: <20010325191424.A60295@ilse.nl> References: <10008.985481400@sss.pgh.pa.us> <20010325015704.A46087@ilse.nl> <10339.985495016@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <10339.985495016@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Sat, Mar 24, 2001 at 11:36:56PM -0500 X-Unexpected-Header: The Spanish Inquisition X-Archive-Number: 200103/488 X-Sequence-Number: 2159 On Sat, Mar 24, 2001 at 11:36:56PM -0500, Tom Lane allegedly wrote: > Mathijs Brands writes: > > How about being able to recompile them (keeping the SQL around in the > > system catalogs)? Doesn't Oracle allow you to do something like that? > > That's another possibility. It's not real clear that there's any > advantage to storing rules in preparsed form to begin with --- if > we just stored the original text and reparsed it each time it was > read, the system would be vastly more flexible, and probably not > noticeably slower. But every bit of performance counts, of course... Mathijs -- "Borrowers of books -- those mutilators of collections, spoilers of the symmetry of shelves, and creators of odd volumes." Charles Lamb (1775-1834)