Re: regclass, \d command and temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: regclass, \d command and temp tables
Date: 2010-08-09 15:16:47
Message-ID: 268.1281367007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <ishii(at)postgresql(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2010-08-09 15:24:47 Re: is syntax columname(tablename) necessary still?
Previous Message Robert Haas 2010-08-09 15:12:48 Re: is syntax columname(tablename) necessary still?