Content-Type: multipart/alternative;
 boundary="------------sytjjMgqS7EOMDhiY7cbDeES"
Message-ID: <eea7fa46-f273-413f-897e-9613591a4f08@shaw.ca>
Date: Tue, 1 Oct 2024 12:08:58 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: George Weaver <gweaver@shaw.ca>
Subject: How to handle "could not find function xml_is_well_formed" when
 restoring database in Version 17
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Language: en-US
Organization: Cleartag Software, Inc.
Archived-At: <https://www.postgresql.org/message-id/eea7fa46-f273-413f-897e-9613591a4f08%40shaw.ca>
Precedence: bulk

This is a multi-part message in MIME format.
--------------sytjjMgqS7EOMDhiY7cbDeES
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Good afternoon,

I am testing upgrading from Version 13 to Version 17.  I am getting the 
following error when trying to restore a database in Version 17 (the 
database was backed up from Version 13 using the Version 17 pg_dump):

    pg_Restore: error: could not execute query: ERROR:  could not find
    function "xml_is_well_formed" in file "C:/Program
    Files/PostgreSQL/17/lib/pgxml.dll"
    Command was: CREATE FUNCTION public.xml_is_well_formed(text) RETURNS
    boolean
         LANGUAGE c IMMUTABLE STRICT
         AS '$libdir/pgxml', 'xml_is_well_formed';

The only reference I can find to xml_is_well_formed in the Release Notes 
(Version 15) is:

    Remove xml2 <https://www.postgresql.org/docs/15/xml2.html>'s
    |xml_is_well_formed()| function (Tom Lane)

    This function has been implemented in the core backend since
    Postgres 9.1

How do I address this in restoring the backup to 17?

Thanks,

George


--------------sytjjMgqS7EOMDhiY7cbDeES
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Good afternoon,</p>
    <p>I am testing upgrading from Version 13 to Version 17.  I am
      getting the following error when trying to restore a database in
      Version 17 (the database was backed up from Version 13 using the
      Version 17 pg_dump):</p>
    <blockquote>
      <p>pg_Restore: error: could not execute query: ERROR:  could not
        find function "xml_is_well_formed" in file "C:/Program
        Files/PostgreSQL/17/lib/pgxml.dll"<br>
        Command was: CREATE FUNCTION public.xml_is_well_formed(text)
        RETURNS boolean<br>
            LANGUAGE c IMMUTABLE STRICT<br>
            AS '$libdir/pgxml', 'xml_is_well_formed';</p>
    </blockquote>
    <p>The only reference I can find to xml_is_well_formed in the
      Release Notes (Version 15) is:         <br>
    </p>
    <blockquote>
      <p>Remove <a class="link"
          href="https://www.postgresql.org/docs/15/xml2.html"
          title="F.50. xml2">xml2</a>'s <code class="function">xml_is_well_formed()</code>
        function (Tom Lane)</p>
      This function has been implemented in the core backend since
      Postgres 9.1<br>
    </blockquote>
    <p>How do I address this in restoring the backup to 17?</p>
    <p>Thanks,</p>
    <p>George<br>
    </p>
    <br>
    <p><br>
    </p>
    <p>   </p>
  </body>
</html>

--------------sytjjMgqS7EOMDhiY7cbDeES--