Re: Creating a session variable in Postgres

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Creating a session variable in Postgres
Дата
Msg-id pc50c0dah4hcqdls42ec14ggi42uahkg9b@email.aon.at
обсуждение исходный текст
Ответ на Re: Creating a session variable in Postgres  ("Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>)
Список pgsql-general
On Fri, 4 Jun 2004 08:25:38 +0200, "Nagib Abi Fadel"
<nagib.abi-fadel@usj.edu.lb> wrote:
>The use of sequence would require to clean up the table every N hour .

Right.

>The use of temporary table wouldn't require any cleanup.

Wrong.  You would have to clean up the meta data, at least pg_class and
pg_attribute, maybe pg_index also.  For the price of one temp table you
can have several rows in a permanent table.

Servus
 Manfred

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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Creating a session variable in Postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'