Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context

> > Hi, I have tested the three issues fixed in patch 001. Array Indexes issue is still there.Running the following query returns ERROR: more than one value returned by column XPath expression SELECT xmltable.* FROM (SELECT data FROM xmldata) x, LATERAL XMLTABLE('/ROWS/ROW' PASSING data C

Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context

resql.org/message-id/attachment/63468/0002-XML-avoid-xmlStrdup-if-possible.patch> Can you let me know what fix is done in patch 002. I will test that as well? Regards, Ram. On Thu, 28 Feb 2019 at 15:01, Pavel Stehule wrote: > > > čt 28. 2. 2019 v 9:58 odesílatel Ramanaraya

Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context

latel Pavel Stehule > napsal: > >> >> >> čt 28. 2. 2019 v 9:58 odesílatel Ramanarayana >> napsal: >> >>> Hi, >>> >>> I have tested the three issues fixed in patch 001. Array Indexes >>> issue is still there.Running the following que

Re: House style for DocBook documentation?

Hi, I have tested bug fixes provided by all the patches. They are working great. I found one minor issue select * from xmltable('*' PASSING 'pre&deeppost' COLUMNS x XML PATH '/'); The above query returns the xml. But there is an extra plus symbol at the end pre&deeppost+ Regards, Ram

Re: PostgreSQL vs SQL/XML Standards

Hi, Yes it is working fine with \a option in psql. Cheers Ram 4.0

Re: psql show URL with help

Hi, Is there any documentation change required for this patch? Cheers Ram 4.0

Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;

Hi, Will it be helpful if the comments section of ExecuteStmt in gram.y is updated to include the IF NOT EXISTS clause.Something like this CREATE TABLE [IF NOT EXISTS] AS EXECUTE [(params, ...)] Regards, Ram.

Unaccent extension python script Issue in Windows

Hi Hackers, In master branch, unaccent extension is having issue with the below python script.This issue is only in windows 10 and python 3. python generate_unaccent_rules.py --unicode-data-file UnicodeData.txt --latin-ascii-file Latin-ASCII.xml > unaccent.rules I am getting the following error

Re: Unaccent extension python script Issue in Windows

Hi Hugh, I have abstracted out the windows compatibility changes from your patch to a new patch and tested it. Added the patch to https://commitfest.postgresql.org/23/ Please feel free to change it if it requires any changes. Cheers Ram 4.0 v1_unaccent_windows_compatibility.patch Description:

Re: Contribution to Perldoc for TestLib module in Postgres

Hi, Can I take this up? Regards, Ram

Re: Contribution to Perldoc for TestLib module in Postgres

Hi, Please find the first version of the patch for review. I was not sure what some of the functions are used for and marked them with TODO. Cheers Ram 4.0 v1_perldoc_testlib.patch Description: Binary data

Re: Problem during Windows service start

Hi, If wait_for_postmaster returns POSTMASTER_STILL_STARTING will it be correct to set the status of windows service to SERVICE_START_PENDING ? I would like to take this up if no one is working on this. Regards, Ram.

Re: Problem during Windows service start

Hi, Please find the proposed patch for review. I will attach it to commitfest as well Regards, Ram. windows_service_bug_fix_v2.patch Description: Binary data

Re: Contribution to Perldoc for TestLib module in Postgres

Hi, Please find the updated patch. Added to the commitfest as well Regards, Ram. v2_perldoc_testlib.patch.patch Description: Binary data

Mailing list not working

Hi, I am not able to access the mailing list archive. Is the mailing list server down or something? -- Cheers Ram 4.0

Re: Mailing list not working

Hi, I also got same error couple of hours ago. Now it is working fine. It would be great to have alerting tools like prometheus to notify users when the server is down Regards, Ram.

Re: BUG #15548: Unaccent does not remove combining diacritical characters

Hi Hugh, I tested the script in python 2.7 and it works perfect. The problem is in python 3.7(and may be only in windows as you were not getting the issue) and I was getting the following error UnicodeEncodeError: 'charmap' codec can't encode character '\u0100' in position 0: character maps to

Re: BUG #15548: Unaccent does not remove combining diacritical characters

from the Operating system.Default encoding in linux and windows might be different.Hence this issue. Regards, Ram. On Tue, 12 Feb 2019 at 09:48, Michael Paquier wrote: > On Tue, Feb 12, 2019 at 02:27:31AM +0530, Ramanarayana wrote: > > I tested the script in python 2.7 and it works per

Re: libpq host/hostaddr/conninfo inconsistencies

Hi, I am getting error while applying patch.I think the patch needs to be redone on the latest code in master as there are some commits in master after the patch is created On Sat, 16 Feb 2019 at 13:44, Fabien COELHO wrote: > > Hello Kyotaro-san, > > > On such standpoint, the first hunk in the

Re: BUG #15548: Unaccent does not remove combining diacritical characters

Hi Hugh, The patch I submitted was tested both in python 2 and 3 and it worked for me.The single line of code added in the patch runs only in python 3. I dont think it can break python2. Would like to see the error you got in python 2 Good to know the reported issue is a valid one in windows.I

Re: libpq debug log

Hi, I have tested the trace log implementation.Please find my feedback for the same. Issues found while testing - 1) If invalid value is given to PGLOGMINLEVEL, empty log file is created which should not happen. 2) If log file size exceeds the value configured in P