Re: SELECT INTO TEMPORARY problem

David Goodenough wrote:
> I thought I understood that the table would disappear
> at the end of the transaction.  Other than deleting it, is there something
> else I need to do or have I missunderstood that into temporary does?

Dropped when the connection is closed normally, but see the ON COMMIT.

http://www.postgresql.org/docs/8.1/static/sql-createtable.html

You might have to do CREATE TABLE then INSERT INTO ... SELECT though.

--
   Richard Huxton
   Archonet Ltd