![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: Unsupported/Unknown Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/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 |
#3
| |||
| |||
|
#4
| |||
| |||
|
|
On 08/08/2012 06:24 PM, rikard.pavelic (AT) zg (DOT) htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: Unsupported/Unknown Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/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 version without 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 |
|
- A description of the problem you are having It doesn't work |
#5
| |||
| |||
|
|
On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pavelic (AT) zg (DOT) htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: 9.2 beta3 Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/msg00231.php - 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 that PostgreSQL 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. |
#6
| |||
| |||
|
|
On 08/14/2012 11:42 PM, Rikard Pavelic wrote: On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pavelic (AT) zg (DOT) htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: 9.2 beta3 Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/msg00231.php - 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 that PostgreSQL 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. OK, I get you. Given the context of the old report this sounds like it could be an installation/packaging issue. I'll ping the EDB folks. Which Windows is it exactly? And did you use the 32-bit or 64-bit installer? -- Craig Ringer Windows 7 64bit |
#7
| |||
| |||
|
|
On 15.8.2012. 3:54, Craig Ringer wrote: On 08/14/2012 11:42 PM, Rikard Pavelic wrote: On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pavelic (AT) zg (DOT) htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: 9.2 beta3 Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/msg00231.php - 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 that PostgreSQL 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. OK, I get you. Given the context of the old report this sounds like it could be an installation/packaging issue. I'll ping the EDB folks. Which Windows is it exactly? And did you use the 32-bit or 64-bit installer? -- Craig Ringer Windows 7 64bit PostgreSQL 9.2beta3, compiled by Visual C++ build 1600, 64-bit |
#8
| |||
| |||
|
|
On Wed, Aug 15, 2012 at 2:37 PM, Rikard Pavelic rikard.pavelic (AT) zg (DOT) htnet.hr> wrote: On 15.8.2012. 3:54, Craig Ringer wrote: On 08/14/2012 11:42 PM, Rikard Pavelic wrote: On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pavelic (AT) zg (DOT) htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pavelic (AT) zg (DOT) htnet.hr PostgreSQL version: 9.2 beta3 Operating system: Windows Description: This is still an issue as reported in http://archives.postgresql.org/pgsql...5/msg00231.php - 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 that PostgreSQL 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. OK, I get you. Given the context of the old report this sounds like it could be an installation/packaging issue. I'll ping the EDB folks. Which Windows is it exactly? And did you use the 32-bit or 64-bit installer? -- Craig Ringer Windows 7 64bit PostgreSQL 9.2beta3, compiled by Visual C++ build 1600, 64-bit This still seems to be an issue in the test beta4 installers rolled this morning. I'm looking into it. |
#9
| |||
| |||
|
|
So Sachin and I have looked at this but not found a problem with the installers. He then found that one of our colleagues has already reported this as an issue with PostgreSQL and submitted a possible patch. So, we need a committer to look at fixing this: http://archives.postgresql.org/pgsql...6/msg00874.php |
#10
| |||
| |||
|
|
Dave Page <dpage (AT) pgadmin (DOT) org> writes: So Sachin and I have looked at this but not found a problem with the installers. He then found that one of our colleagues has already reported this as an issue with PostgreSQL and submitted a possible patch. So, we need a committer to look at fixing this: http://archives.postgresql.org/pgsql...6/msg00874.php Seems pretty brute-force. Why not just #if LIBXML_VERSION > 20703 #define HAVE_XMLSTRUCTUREDERRORCONTEXT #endif in some suitable place (probably xml.c itself, since I don't think we want to #include xmlversion.h in global headers)? Or actually, maybe we could just unconditionally define HAVE_XMLSTRUCTUREDERRORCONTEXT in pg_config.h.win32. Is anybody likely to still be building PG with ancient libxml on Windows? |
![]() |
| Thread Tools | |
| Display Modes | |
| |