|
Posted by Jerry Sievers on 11/12/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/
Navigation:
[Reply to this message]
|