The DROP TABLE instruction should have a TEMP option for when atemporary table

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема The DROP TABLE instruction should have a TEMP option for when atemporary table
Дата
Msg-id 153999002350.30914.3114277646917994661@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: The DROP TABLE instruction should have a TEMP option for when a temporary table
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.3/static/sql-createtable.html
Description:

Hi,

There is an obvious "issue" with temporary tables.

Case description:
We have a public table     public."myTooImportantTable"

Then you have a temporary table:
;CREATE TEMP TABLE "myTooImportantTable"

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"

В списке pgsql-docs по дате отправления: