Re: The DROP TABLE instruction should have a TEMP option for when a temporary table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: The DROP TABLE instruction should have a TEMP option for when a temporary table
Дата
Msg-id 22268.1539995600@sss.pgh.pa.us
обсуждение исходный текст
Ответ на The DROP TABLE instruction should have a TEMP option for when atemporary table  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: The DROP TABLE instruction should have a TEMP option for when atemporary table  (Pablo Benito <bioingbenito@gmail.com>)
Список pgsql-docs
Дерево обсуждения 
=?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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: The DROP TABLE instruction should have a TEMP option for when atemporary table
Следующее
От: Pablo Benito
Дата:
Сообщение: Re: The DROP TABLE instruction should have a TEMP option for when atemporary table