> It works for me. Are you using clean sources? > > regression=# create table t1(i int); > CREATE TABLE > regression=# select 't1'::regclass::oid; > oid > -------- > 127671 > (1 row) > > regression=# create temp table t1(i int, j int); > CREATE TABLE > regression=# select 't1'::regclass::oid; > oid > -------- > 127674 > (1 row)
Oops. Sorry for noise. I accidentaly accessed through pgpool and it load balanced the SELECT to different PostgreSQL server. Pgpool should have remebered that temporary tables are created in the session. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers