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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: GPT
Дата:
Сообщение: Re: Doc creation failed (v10.5 & 11)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: The DROP TABLE instruction should have a TEMP option for when a temporary table