lifetime of temp schema versus compiled image of plpgsql proc
От | Dennis |
---|---|
Тема | lifetime of temp schema versus compiled image of plpgsql proc |
Дата | |
Msg-id | courier.40881D1C.0000705D@wolverine.lercnetworks.com обсуждение исходный текст |
Ответы |
Re: lifetime of temp schema versus compiled image of plpgsql proc
Re: lifetime of temp schema versus compiled image of plpgsql proc |
Список | pgsql-sql |
Hi, this is pg 7.4.1 I am opening a connection to postgres starting a transaction executing a plpgsql function that creates temp tables executing a plpgsql function that populates the temp tables querying the temp table closing the transaction then on the same connection, I open a transaction, execute a plpgsql function that populates the temp tables and the function bombs with this error message: ERROR: schema "pg_temp_8" does not exist I am not specifying "on commit" when creating the temp tables. Are temp tables created in a transaction discarded when the transaction ends? I'm not explicitly referencing pg_temp_8 in my stored function. Can someone explain what is going on? Have I given enough information? dennis pg-user at calico dash consulting dot com
В списке pgsql-sql по дате отправления: