Re: Drop only temporary table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Drop only temporary table
Date: 2016-03-18 13:27:23
Message-ID: 15709.1458307643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Durumdara <durumdara(at)gmail(dot)com> writes:
> As I experienced I can create normal and temp table with same name.

Sure.

> As I see that drop table stmt don't have "temporary" suboption to determine
> which to need to eliminate - the real or the temporary.

Once you've created a temp table, it masks any normal table of the same name
(unless you use a schema-qualified reference to the normal table).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aleksander Alekseev 2016-03-18 13:31:10 Re: Drop only temporary table
Previous Message Durumdara 2016-03-18 12:47:06 Drop only temporary table