Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of temporary tables in functions - Mailing list pgsql-general

From Patrick.FICHE@AQSACOM.COM
Subject Re: Use of temporary tables in functions
Date
Msg-id 1DC6C8C88D09D51181A40002A5286929B22DD7@intranet
Whole thread Raw
In response to Use of temporary tables in functions  (Patrick.FICHE@AQSACOM.COM)
List pgsql-general
Tree view
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
-------------------------------------------------------------------------------------------

 

pgsql-general by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: FW: How to install Postgres that supports 64-bit integer/date-time.
Next
From: Sebastian Böck
Date:
Subject: Re: Multiple RULES on Views