PL/PgSQL and pg_temp pseudo-schema

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: PL/PgSQL and pg_temp pseudo-schema
Date: 2015-02-20 08:07:48
Message-ID: CAHjZ2x7hSbjsc5JK79c7L7dtO9-oeCPURCM3ivPXeeNyaZ2vPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PL/PgSQL doesn't know the pg_temp meta schema in case you need to
really work on that TEMP TABLE.
At the moment I had to move those DDL/DML queries within a "plain" SQL function.

Is this a feature or a bug? (Seriously, I mean! :-)

TIA.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2015-02-20 08:34:32 Re: PL/PgSQL and pg_temp pseudo-schema
Previous Message Pavel Stehule 2015-02-20 05:09:20 Re: stored procedure variable names