DROP [TEMP] TABLE syntax, as reason why not?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: DROP [TEMP] TABLE syntax, as reason why not?
Date: 2017-08-23 22:09:32
Message-ID: CAKFQuwZGCBAiid5kjR=mxCnFvM+fwByWHYue8tDhLT7rEyevcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all,

I'm wondering if there is anything technical preventing someone from making:

DROP TEMP TABLE tablename;

work. Implementation wise the command would fail if a temporary table of
the given name doesn't exist. Today, if a temporary table exists it will
be dropped, but if tablename is not schema-qualified and a table with the
same names exists in the search path it would be dropped.

Plus its symmetrical with CREATE [TEMP] TABLE.

David J.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2017-08-23 23:33:56 jdbc driver vis Release 10
Previous Message Stephen Frost 2017-08-23 18:40:06 Re: PG and database encryption