Re: [BUGS] BUG #5798: Some weird error with pl/pgsql procedure

2010-12-22 Thread Maxim Boguk
It happened again in much simpler case (no slony or deadlock message involved... no slony at all on the database). The same error DBD::Pg::db selectall_arrayref failed: ERROR: cannot extract system attribute from virtual tuple CONTEXT: PL/pgSQL function "__clear_table_tail" line 50 at FOR over E

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

2010-12-22 Thread Bruce Momjian
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 requirements to be marked IMMUTABLE. > > No, it most certainly do