Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDfCo-00067g-Sr for pgsql-docs@arkaria.postgresql.org; Sat, 20 Oct 2018 00:33:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gDfCm-0002mB-Pw for pgsql-docs@arkaria.postgresql.org; Sat, 20 Oct 2018 00:33:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDfCm-0002m4-KK for pgsql-docs@lists.postgresql.org; Sat, 20 Oct 2018 00:33:24 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDfCk-0005IL-Mw for pgsql-docs@lists.postgresql.org; Sat, 20 Oct 2018 00:33:24 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w9K0XK5o022269; Fri, 19 Oct 2018 20:33:20 -0400 From: Tom Lane To: bioingbenito@gmail.com cc: pgsql-docs@lists.postgresql.org Subject: Re: The DROP TABLE instruction should have a TEMP option for when a temporary table In-reply-to: <153999002350.30914.3114277646917994661@wrigleys.postgresql.org> References: <153999002350.30914.3114277646917994661@wrigleys.postgresql.org> Comments: In-reply-to =?utf-8?q?PG_Doc_comments_form?= message dated "Fri, 19 Oct 2018 23:00:23 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <22267.1539995600.1@sss.pgh.pa.us> Date: Fri, 19 Oct 2018 20:33:20 -0400 Message-ID: <22268.1539995600@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk =?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 to be sure you drop a temp table and not a regular one, say DROP TABLE pg_temp.mytable; There's no need for new syntax. regards, tom lane