Thanks, will test rebased version. BTW, that is not the temp variable. You can note it because of the schema or the lack of a "Transaction end action". That is a normal non-temp variable that has been created before. A TEMP variable with an ON COMMIT DROP created outside an explicit transaction will disappear immediatly like cursor does in the same situation.
Unfortunately, I don't see it - or I don't understand to your example from morning mail well
""" regression=# create temp variable random_number numeric ; CREATE VARIABLE regression=# \dV List of variables Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transaction al end action -----------+---------------+---------+-------------+------------+---------+----------+------------ -------------- pg_temp_4 | random_number | numeric | t | t | | jcasanov | (1 row)
regression=# select public.random_number; ERROR: missing FROM-clause entry for table "public" LINE 1: select public.random_number; ^ """
-- Jaime Casanova Director de Servicios Profesionales SystemGuards - Consultores de PostgreSQL