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

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: bioingbenito(at)gmail(dot)com
Subject: The DROP TABLE instruction should have a TEMP option for when a temporary table
Date: 2018-10-19 23:00:23
Message-ID: 153999002350.30914.3114277646917994661@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2018-10-20 00:33:20 Re: The DROP TABLE instruction should have a TEMP option for when a temporary table
Previous Message GPT 2018-10-19 15:55:43 Re: Doc creation failed (v10.5 & 11)