David Goodenough wrote:
I thought I understood that the table would disappear at the end of the transaction. Other than deleting it, is there somethingelse 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
