Re: [SQL] temporary views

2001-10-07 Thread Bruce Momjian
> Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Bruce Momjian writes: > >> * Allow views on temporary tables to behave as temporary views > > > I don't think this is a good idea. Especially since our temp tables are > > allowed to shadow persistent tables, it would not be obvious whether the

Re: [SQL] temporary views

2001-10-07 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bruce Momjian writes: >> * Allow views on temporary tables to behave as temporary views > I don't think this is a good idea. Especially since our temp tables are > allowed to shadow persistent tables, it would not be obvious whether the > view you'r

Re: [SQL] PlPerl

2001-10-07 Thread Alex Pilosov
On Mon, 8 Oct 2001, Aasmund Midttun Godal wrote: > 1. Is there a plperlu? ... unsafe version of perl? In 7.2, there will be. In 7.1, you have to apply patches manually. > 2. Is it possible to select which packages the plperl should have access to? In 7.2, plperlu can do anything. plperl in eithe

[SQL] PlPerl

2001-10-07 Thread Aasmund Midttun Godal
1. Is there a plperlu? ... unsafe version of perl? 2. Is it possible to select which packages the plperl should have access to? 3. What exactly can you and can't you do. Thank you for your attention. Aasmund Midttun Godal [EMAIL PROTECTED] - http://www.godal.com/ +47 40 45 20 46 --

Re: [SQL] temporary views

2001-10-07 Thread Peter Eisentraut
Bruce Momjian writes: > Seems like a TODO item, at least. What we could do is to create views > as TEMP if they use temp tables and drop the view as soon as the session > ends . You of course would have to recreate the view each time but > because it is a _temp_ view, it could be done reliably