You may want to suggest to the devs to extend the "UPDATE" syntax with
"ORDER BY"? such that:
update rumple.directory
set right_visit_id = right_visit_id + 2
where right_visit_id >= parent_right
ORDER BY right_visit_id DESC;
...would work by enforcing a certain update order. And index scan is
The following bug has been logged online:
Bug reference: 5472
Logged by: Vlad Romascanu
Email address: vromasc...@accurev.com
PostgreSQL version: 8.4.3
Operating system: Windows, Linux
Description:Postgres hard crash in ...WHERE IN (SELECT
* FROM (VALUES (),...) AS
bove will pass with flying colours on 64-bit builds if
USE_FLOAT8_BYVAL ends up being #defined.
Cheers,
V.
-Original Message-
From: Alex Hunsaker [mailto:bada...@gmail.com]
Sent: Tuesday, May 25, 2010 1:27 PM
To: Vlad Romascanu
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5472: Postg
The following bug has been logged online:
Bug reference: 5743
Logged by: Vlad Romascanu
Email address: vromasc...@accurev.com
PostgreSQL version: 8.4.3
Operating system: Windows, Linux
Description:Regexp engine fails to case-insensitively match
multi-byte codepoints
