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

2018-10-21 Thread Pablo Benito
Hi Tom, Thanks a lot, for the response! Yes, you are right, there is a secure way for drops, prefixing with the schema name. But, for this particular case, TEMPORARY tables, as a special way for CREATE TABLE, It would be good to have also an special way for DROP TABLE. (It is just an opinion) To

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

2018-10-19 Thread Tom Lane
=?utf-8?q?PG_Doc_comments_form?= 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

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

2018-10-19 Thread PG Doc comments form
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