Use of temporary tables in functions

Started by Patrick Fichealmost 21 years ago2 messagesgeneral
Jump to latest
#1Patrick Fiche
patrick.fiche@aqsacom.com

Hi,

I had some issues with previous versions of Postgresql using temporary
tables in functions.
The main issue was that the both indexes pg_attribute_relid_attnam_index and
pg_attribute_relid_attnum_index were always growing and I had to restart
postgresql in single mode and run a REINDEX command to free some space on
the disk.

Does the problem still exist in version 8 ?
Thanks for your answers.

Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

#2Patrick Fiche
patrick.fiche@aqsacom.com
In reply to: Patrick Fiche (#1)
Re: Use of temporary tables in functions

My Postgresql version was 7.2.3.
I guess that this was fixed in a more recent version but I could not find it
in the version history...
Could anybody confirm that this was fixed.

Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of
Patrick.FICHE@AQSACOM.COM
Sent: jeudi 21 avril 2005 15:33
To: pgsql-general@postgresql.org
Subject: [GENERAL] Use of temporary tables in functions

Hi,

I had some issues with previous versions of Postgresql using temporary
tables in functions.
The main issue was that the both indexes pg_attribute_relid_attnam_index and
pg_attribute_relid_attnum_index were always growing and I had to restart
postgresql in single mode and run a REINDEX command to free some space on
the disk.

Does the problem still exist in version 8 ?
Thanks for your answers.

Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------