Postgres Pro
Downloads
Home   >   mailing lists

Re: The DROP TABLE instruction should have a TEMP option for when a temporary table - Mailing list pgsql-docs

From Tom Lane
Subject Re: The DROP TABLE instruction should have a TEMP option for when a temporary table
Date
Msg-id 22268.1539995600@sss.pgh.pa.us
Whole thread Raw
In response to The DROP TABLE instruction should have a TEMP option for when atemporary table  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: The DROP TABLE instruction should have a TEMP option for when atemporary table  (Pablo Benito <bioingbenito@gmail.com>)
List pgsql-docs
Tree view 
=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> The issue is related to the intention of drop the temporary table:
> ;DROP TABLE "myTooImportantTable"   -- <--- this drop the 
> "myTooImportantTable" 
> ;DROP TABLE "myTooImportantTable" -- <--- this drop the
> public."myTooImportantTable"

If you want to be sure you drop a temp table and not a regular one, say

DROP TABLE pg_temp.mytable;

There's no need for new syntax.

            regards, tom lane

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: The DROP TABLE instruction should have a TEMP option for when atemporary table
Next
From: Pablo Benito
Date:
Subject: Re: The DROP TABLE instruction should have a TEMP option for when atemporary table