Re: [HACKERS] regclass, \d command and temp tables

2010-08-09 Thread Tatsuo Ishii
> 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::o

Re: [HACKERS] regclass, \d command and temp tables

2010-08-09 Thread Tom Lane
Tatsuo Ishii writes: > I have created regular table t1 and temp table t1. Regclass and \d > command do not seem to distinguish them. Is this normal? It works for me. Are you using clean sources? regression=# create table t1(i int); CREATE TABLE regression=# select 't1'::regclass::oid; oid

[HACKERS] regclass, \d command and temp tables

2010-08-09 Thread Tatsuo Ishii
Hi, I have created regular table t1 and temp table t1. Regclass and \d command do not seem to distinguish them. Is this normal? test=# create table t1(i int); CREATE TABLE test=# select 't1'::regclass::oid; oid - 1470776 (1 row) test=# create temp table t1(i int, j int); CREATE TA