Re: Drop only temporary table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Drop only temporary table
Date: 2016-03-18 14:58:26
Message-ID: CAKFQuwZLenCB=ovLEqV5MbQ+B-a6wseFRYMZ+TEWmmbtJAKNow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, March 18, 2016, Durumdara <durumdara(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-03-18 14:59:35 Re: spurious /dev/shm related errors on insert
Previous Message Michael Charnoky 2016-03-18 14:45:50 Re: spurious /dev/shm related errors on insert