Re: read only transaction, temporary tables

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: read only transaction, temporary tables
Дата
Msg-id 20060812113521.GB16270@svana.org
обсуждение исходный текст
Ответ на Re: read only transaction, temporary tables  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: read only transaction, temporary tables
Список pgsql-general
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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Connection string
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Jasper Reports