Re: PL/PgSQL and pg_temp pseudo-schema

Hi

It is little bit strange, it works for me

postgres=# create temp table foo(a int);
CREATE TABLE
postgres=# do $$ begin insert into foo values(10); end $$; -- plpgsql
DO
postgres=# select * from foo;
a
----
10
(1 row)

Regards

Pavel

2015-02-20 9:07 GMT+01:00 Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>:

> 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>