Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not? - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?
Date
Msg-id 5297.1503536881@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> I'm wondering if there is anything technical preventing someone from making:

> DROP TEMP TABLE tablename;

There is no great need for that because you can get the semantics you're
asking for with "DROP TABLE pg_temp.tablename".

            regards, tom lane

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: [GENERAL] jdbc driver vis Release 10
Next
From: Kevin Golding
Date:
Subject: [GENERAL] 'value too long' and before insert/update trigger