On 8.8.2012. 13:30, Craig Ringer wrote:
> On 08/08/2012 06:24 PM, rikard.pavelic@zg.htnet.hr wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7485
>> Logged by: Rikard Pavelic
>> Email address: rikard.pavelic@zg.htnet.hr
>> PostgreSQL version: Unsupported/Unknown
>> Operating system: Windows
>> Description:
>>
>> This is still an issue as reported in
>> http://archives.postgresql.org/pgsql-bugs/2012-05/msg00231.php
>>
>> While on topic of XML is there any workaround for this?
>> CREATE TABLE data (id int, x xml);
>> SELECT t FROM data t GROUP BY t;
>>
>> I'm not really sure what operator to create. I'm fine with xml being
>> compared like text
> Your report confuses me somewhat. You've linked to an issue that is extremely specific to one particular PostgreSQL
versionwithout providing the version you are using or details about your OS. You
> then mention the need to create an operator, which seems to have nothing to do with the problem you linked to.
>
> Please follow up with:
>
> - Your PostgreSQL version
I've put it in the subject, because version selector didn't have it (9.2 beta3)
> - How you installed PostgeSQL (ie the EnterpriseDB installer, from source, .zip install)
I've used EnterpriseDB installer (9.2 beta2 with this bug, and now 9.2 beta3)
> - The error message you are getting and the command(s) that cause it
ERROR: could not set up XML error handler
SQL state: 0A000
Hint: This probably indicates that the version of libxml2 being used is not compatible with the libxml2 header files
thatPostgreSQL was built with.
I'm calling function with type that has an XML attribute.
I can provide a test case, but since this is just a warning of the old bug I didn't.
> - A description of the problem you are having
It doesn't work :D
The other question I asked should probably be a second bug report,
but I tried and failed to squeeze it into this one ;(
Regards,
Rikard