Cindy Moore wrote:
I looked through the lists and couldn't figure out where else to put
this. I'm trying to create indices on xpath expressions for columns
of type xml.
I'm running postgres version 8.3.3, running on solaris.
Text=# create index trclass on lsj_xml ((xpath
('//[EMAIL PROTECTED]"t
The following bug has been logged online:
Bug reference: 4414
Logged by: Rudolf Leitgeb
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Mac OSX, linux
Description:PQescapeByteaInternal very slow/inefficient
Details:
PQescapeByteaInternal
"Rudolf Leitgeb" <[EMAIL PROTECTED]> writes:
> PQescapeByteaInternal uses sprintf to convert a byte to its octal
> representation, which slows down escaping of large BLOBs significantly.
Good point. Fixed in HEAD and 8.3 branches.
regards, tom lane
--
Sent via pgsql-bug
We have a query that returns a different result in 8.2.5 and 8.3.0.
This is the query, I apologize for the names and aliases, it is
hibernate-generated.
select * from action_items actionitem0_
left outer join action_item_states states1_ on
actionitem0_.id=states1_.action_item_id
where (
Joe Uhl <[EMAIL PROTECTED]> writes:
> We have a query that returns a different result in 8.2.5 and 8.3.0.
I think this is the same bug discussed yesterday:
http://archives.postgresql.org/pgsql-bugs/2008-09/msg00078.php
regards, tom lane
--
Sent via pgsql-bugs mailing
Joe Uhl <[EMAIL PROTECTED]> writes:
> We have a query that returns a different result in 8.2.5 and 8.3.0.
> ...
> The result in 8.3.0 is what we expect.
I guess I read a little too fast, because I overlooked that comment.
It's the 8.3.0 plan that is broken in my opinion --- it shouldn't be
push
Possibly, I saw that thread but may not have dug into the content
deeply enough. My apologies if this is the case, i'll check it out
further.
On Sep 10, 2008, at 3:38 PM, Tom Lane wrote:
Joe Uhl <[EMAIL PROTECTED]> writes:
We have a query that returns a different result in 8.2.5 and 8.3.0
