2012/4/20 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Fri, Apr 20, 2012 at 10:36 AM, Vincenzo Romano
> <vincenzo(dot)romano(at)notorand(dot)it> wrote:
>> Hi all.
>> I'd like use a temporary view "to hide" a non-temp one for some queries.
>> Later I'd need to drop that view in order to "revert to normal operations".
>> As there is no "DROP TEMPORARY VIEW ..." I'd be forced to "CREATE OR
>> REPLACE TEMPORARY VIEW ..." in order to "overwrite" the temporary one
>> with the same code as the non-temporary.
>> All this sounds quite complex to me. Is there a way to drop temporary
>> stuff before closing the session?
> you can do it with vanilla DROP VIEW:
> postgres=# create temp view t as select 1;
> CREATE VIEW
> postgres=# drop view t;
> DROP VIEW
Ok. That works. How can I know if there's a temporary view with the
same name in my session?
In response to
pgsql-general by date
|Next:||From: Merlin Moncure||Date: 2012-04-20 15:59:13|
|Subject: Re: How to drop a temporary view?|
|Previous:||From: Chris Angelico||Date: 2012-04-20 15:46:28|
|Subject: Re: pg_advisory_lock() and row deadlocks|