[SQL] lifetime of temp schema versus compiled image of plpgsql proc

[Dennis]

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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match