temporary table oddity

From: jwsacksteder(at)ramprecision(dot)com
To: pgsql-general(at)postgresql(dot)org
Cc: jwsacksteder(at)ramprecision(dot)com
Subject: temporary table oddity
Date: 2003-03-20 19:28:22
Message-ID: 71650A6F73F1D411BE8000805F65E3CB3B319B@SRV-03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-20 19:38:50 don't understand something about backslashes
Previous Message Darren Ferguson 2003-03-20 18:34:13 Re: Extracting time from timestamp