From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: regclass, \d command and temp tables |
Date: | 2010-08-09 15:25:21 |
Message-ID: | 20100810.002521.68318492.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2010-08-09 15:28:57 | Re: review: psql: edit function, show function commands patch |
Previous Message | Pavel Stehule | 2010-08-09 15:24:47 | Re: is syntax columname(tablename) necessary still? |