Thread: Use of temporary tables in functions

-----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
-------------------------------------------------------------------------------------------