Re: regclass, \d command and temp tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: regclass, \d command and temp tables
Date
Msg-id 268.1281367007@sss.pgh.pa.us
Whole thread Raw
In response to regclass, \d command and temp tables  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: regclass, \d command and temp tables
List pgsql-hackers
Tatsuo Ishii <ishii@postgresql.org> 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   
--------127671
(1 row)

regression=# create temp table t1(i int, j int);
CREATE TABLE
regression=# select 't1'::regclass::oid; oid   
--------127674
(1 row)

        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: is syntax columname(tablename) necessary still?
Next
From: Pavel Stehule
Date:
Subject: Re: is syntax columname(tablename) necessary still?