Re: [BUGS] BUG #5781: unaccent() function should be marked IMMUTABLE

2010-12-24 Thread Robert Haas
On Wed, Dec 22, 2010 at 8:45 PM, Bruce Momjian wrote: > Tom Lane wrote: >> "Grant Hutchins and Peter Jaros" writes: >> > The unaccent(text) function supplied by contrib/unaccent is marked >> > VOLATILE. >> > This prevents it from being used in indexes. We believe that the function >> > meets the

Re: [BUGS] memory leaks? using savepoint

2010-12-24 Thread Robert Haas
On Tue, Dec 21, 2010 at 11:09 PM, Tom Lane wrote: > So if we take the complaint seriously, we'd better patch 8.2 as well. I'm sort of inclined to think we should take the complaint seriously. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent vi

Re: [BUGS] insert statement going into infinite loop

2010-12-24 Thread Craig Ringer
On 12/24/2010 10:57 PM, Trimurthulu Bandaru wrote: Hi everybody.. I have table with 11 attributes, 6 of them refers different tables and having one primary key. when I am trying to insert row with 121 key value, its going into infinite loop.. Do you have any triggers on the table? Can you prod

Re: [BUGS] insert statement going into infinite loop

2010-12-24 Thread Jaime Casanova
On Fri, Dec 24, 2010 at 6:57 AM, Trimurthulu Bandaru wrote: > Hi everybody.. > I have table with 11 attributes, 6 of them refers different tables and > having one primary key. > when I am trying to insert row with 121 key value, its going into > infinite loop.. define "infinite loop", the truth i

[BUGS] insert statement going into infinite loop

2010-12-24 Thread Trimurthulu Bandaru
Hi everybody.. I have table with 11 attributes, 6 of them refers different tables and having one primary key. when I am trying to insert row with 121 key value, its going into infinite loop.. I didnt find any error in table definition and no foreign key violations.. Can you please help me in this i