regclass, \d command and temp tables
| От | Tatsuo Ishii |
|---|---|
| Тема | regclass, \d command and temp tables |
| Дата | |
| Msg-id | 20100810.001014.95808425.t-ishii@sraoss.co.jp обсуждение исходный текст |
| Ответы |
Re: regclass, \d command and temp tables
|
| Список | pgsql-hackers |
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 TABLE
test=# select 't1'::regclass::oid; oid
---------1470776 <-- why same oid?
(1 row)
test=# \d t1 <-- \d finds regular table, not temporary table?
Table "public.t1"Column | Type | Modifiers
--------+---------+-----------i | integer |
test=# insert into t1 values(1,2); <-- insert command works as expected of course.
INSERT 0 1
test=# select * from t1;i | j
---+---1 | 2
(1 row)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: