Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i

> Hi,
>
> I'm running v7.1.2. In psql, if I
>
> CREATE TEMPORARY TABLE junk (col1 SERIAL, <more cols>)
>
> and check \ds, the implicitely created sequence is shown but \di doesn't
> show
> the implicitely created index.

OK, here is a patch that fixes it so the sequence is temporary like
everything else. It also adds CREATE TEMPORARY SEQUENCE to the syntax.

test=> create temp table kkk(x serial);
NOTICE: CREATE TABLE will create implicit sequence 'kkk_x_seq' for
SERIAL column 'kkk.x'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'kkk_x_key' for
table 'kkk'
CREATE
test=> \d
No relations found.
test=> \di
No relations found.
test=> \dS
List of relations
Name | Type | Owner
----------------+----------+----------
...
pg_temp_5396_0 | sequence | postgres
pg_temp_5396_1 | table | postgres

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026