Postgres Pro
Downloads
Home   >   mailing lists

PL/PgSQL and pg_temp pseudo-schema - Mailing list pgsql-general

From Vincenzo Romano
Subject PL/PgSQL and pg_temp pseudo-schema
Date
Msg-id CAHjZ2x7hSbjsc5JK79c7L7dtO9-oeCPURCM3ivPXeeNyaZ2vPg@mail.gmail.com
Whole thread Raw
Responses Re: PL/PgSQL and pg_temp pseudo-schema  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: stored procedure variable names
Next
From: Pavel Stehule
Date:
Subject: Re: PL/PgSQL and pg_temp pseudo-schema