From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | jwsacksteder(at)ramprecision(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: temporary table oddity |
Date: | 2003-03-22 17:56:47 |
Message-ID: | 200303221756.h2MHulk18251@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In < 7.3, that is the internal table name. References to the table will
still work.
In 7.3 all temp tables are in their own schema, so they have usual
names.
---------------------------------------------------------------------------
jwsacksteder(at)ramprecision(dot)com wrote:
> If I try to make a temporary table like this-
>
> create temporary table current_inventory AS
> select * from inventory where qty > 0
>
> - I get a table called 'pg_temp_4473_0' instead of my specified name.
>
> What gives? Why did this stop working for me?
>
> (Please respond directly to me. I'm not currently subscribed)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-22 18:05:13 | Re: 32/64-bit transaction IDs? |
Previous Message | Doug McNaught | 2003-03-22 17:50:18 | Re: Problems with deleting data. |