| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Itzinger, Oskar" <oitzinger(at)opec(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [Help] Temporary Table: Implicitely created index not shown in \d i |
| Date: | 2001-06-21 18:54:45 |
| Message-ID: | 200106211854.f5LIsjM28638@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
> 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.
You have found a good bug. The code knows how to create TEMPORARY
tables and indexes, but not temporary sequences. What is happening is
that the sequence created is not temporary and will not go away after
session termination.
I will work on fixing it.
The reason the table or index doesn't appear is because temporary stuff
doesn't appear in \d commands.
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-21 18:58:31 | Re: WAL failure? |
| Previous Message | will trillich | 2001-06-21 18:37:03 | Re: Re: Newbie question: How to check how many tables avaliable at that database? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-21 22:23:03 | Re: use GUC for cmdline |
| Previous Message | Karel Zak | 2001-06-21 12:00:03 | Re: nocreatetable for 7.1.2 |