Re: read only transaction, temporary tables

On Sat, Aug 12, 2006 at 08:57:49AM +0200, Peter Eisentraut wrote:
> > It does seem a bit inconsistent that we allow you to write into a
> > temp table during a "READONLY" transaction, but not to create/drop
> > one. I'm not excited about changing it though, as the tests to see if
> > the command is allowed would become vastly more complex.
>
> Temporary tables in the SQL standard are permanent objects, which is why
> creating or dropping them is a durable operation and not allowed in
> read-only transactions.  It would probably make sense to allow creating
> or dropping PostgreSQL-style temporary tables, though.

Temporary tables still get an entry in pg_class, so for truly readonly
systems they wouldn't work. If you can fix that though it might be
doable.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.