Posted by Jerry Sievers on 12/08/29 11:29

Oli Filth <catch@olifilth.co.uk> writes:

> Temporary tables are exactly that - temporary. They are designed to be
> used for a short period of time, e.g. within one SQL transaction.

Perhaps. This may depend on what DB you're using.

In Postgres (7.4.1) temp tables have the lifetime of a backend session
unless dropped explicitly.

Within transactions, the temp table will exist after the transaction
if same is commited, but disappear on a rollback. (as we might
expect).

HTH

--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/

[Back to original message]