Re: all views in database broken at once - Mailing list pgsql-sql

From Mathijs Brands
Subject Re: all views in database broken at once
Date
Msg-id 20010325191424.A60295@ilse.nl
Whole thread Raw
In response to Re: all views in database broken at once  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: all views in database broken at once  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
On Sat, Mar 24, 2001 at 11:36:56PM -0500, Tom Lane allegedly wrote:
> Mathijs Brands <mathijs@ilse.nl> 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 thesymmetry of shelves, and creators of odd
volumes."       Charles Lamb (1775-1834) 
 


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: all views in database broken at once
Next
From: Bruno Wolff III
Date:
Subject: Re: String REPLACE function