temporary table oddity - Mailing list pgsql-general

From jwsacksteder@ramprecision.com
Subject temporary table oddity
Date
Msg-id 71650A6F73F1D411BE8000805F65E3CB3B319B@SRV-03
Whole thread Raw
Responses Re: temporary table oddity  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: "Jessie Hui"
Date:
Subject: Re: About tcp connection
Next
From: "Frederic S"
Date:
Subject: Problems with deleting data.