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
Tatsuo Ishii is...@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
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