On 03/05/2015 11:01 AM, Igor Neyman wrote:
>
>
>>> Sorry, my reply was based on (old) Oracle knowledge.
>>> Now, I'm wondering too, why PG didn't implement such basic (at least to
>> me) feature.
>>
>> Per my previous post, see:
>>
>> http://www.postgresql.org/docs/9.4/interactive/sql-createtable.html
>>
>> Compatibility
>>
>> The CREATE TABLE command conforms to the SQL standard, with exceptions
>> listed below.
>>
>> Temporary Tables
>> ....
>>>
>>> Regards,
>>> Igor Neyman
>>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
>
>
> m.b. I'm missing something, but this quote from docs doesn't explain "why", it just states that feature is not
implemented.
"The SQL standard also distinguishes between global and local temporary
tables, where a local temporary table has a separate set of contents for
each SQL module within each session, though its definition is still
shared across sessions. Since PostgreSQL does not support SQL modules,
this distinction is not relevant in PostgreSQL.
"
>
> Regards,
> Igor Neyman
>
--
Adrian Klaver
adrian.klaver@aklaver.com