From: | Patrick(dot)FICHE(at)AQSACOM(dot)COM |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Use of temporary tables in functions |
Date: | 2005-04-22 07:36:06 |
Message-ID: | 1DC6C8C88D09D51181A40002A5286929B22DD7@intranet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of
Patrick(dot)FICHE(at)AQSACOM(dot)COM
Sent: jeudi 21 avril 2005 15:33
To: pgsql-general(at)postgresql(dot)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(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2005-04-22 07:43:40 | Re: Get timestamp as UTC |
Previous Message | David Wheeler | 2005-04-22 06:45:30 | Multiple RULES on Views |