Re: Drop only temporary table - Mailing list pgsql-general

From David G. Johnston
Subject Re: Drop only temporary table
Date
Msg-id CAKFQuwZLenCB=ovLEqV5MbQ+B-a6wseFRYMZ+TEWmmbtJAKNow@mail.gmail.com
Whole thread Raw
In response to Drop only temporary table  (Durumdara <durumdara@gmail.com>)
List pgsql-general
On Friday, March 18, 2016, Durumdara <durumdara@gmail.com> wrote:

I want to avoid to remove any real table on resource closing (= dropping of temporary table).
How to I force "drop only temporary"? Prefix, option, etc.


If you have to explicitly drop a temporary table you are likely doing something wrong.  When you create the table you tell it when to go away and at that time it will - no need for a drop statement.

David J. 

pgsql-general by date:

Previous
From: Michael Charnoky
Date:
Subject: Re: spurious /dev/shm related errors on insert
Next
From: Tom Lane
Date:
Subject: Re: spurious /dev/shm related errors on insert