Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Doc comments form
Subject The DROP TABLE instruction should have a TEMP option for when atemporary table
Date
Msg-id 153999002350.30914.3114277646917994661@wrigleys.postgresql.org
Whole thread Raw
Responses Re: The DROP TABLE instruction should have a TEMP option for when a temporary table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
Tree view 
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 by date:

Previous
From: GPT
Date:
Subject: Re: Doc creation failed (v10.5 & 11)
Next
From: Tom Lane
Date:
Subject: Re: The DROP TABLE instruction should have a TEMP option for when a temporary table