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.
signature.asc
Description: Digital signature
