Re: Creating a session variable in Postgres
От | Nagib Abi Fadel |
---|---|
Тема | Re: Creating a session variable in Postgres |
Дата | |
Msg-id | 009701c44a14$50c510b0$f664a8c0@nagib обсуждение исходный текст |
Ответ на | Re: Creating a session variable in Postgres (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Creating a session variable in Postgres
|
Список | pgsql-general |
So considering those facts, it would be better to use the Sequence Method, since it would only require cleaning up one table .... Or is there anything else i am missing ??? ----- Original Message ----- From: "Manfred Koizar" <mkoi-pg@aon.at> To: "Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb> Cc: "Mike Mascari" <mascarm@mascari.com>; "Bruce Momjian" <pgman@candle.pha.pa.us>; "generalpost" <pgsql-general@postgresql.org> Sent: Friday, June 04, 2004 08:32 AM Subject: Re: [GENERAL] Creating a session variable in Postgres > 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 по дате отправления: