public inbox for [email protected]  

help / color / mirror / Atom feed

From: George Weaver <[email protected]>
To: [email protected] <[email protected]>
Subject: How to handle "could not find function xml_is_well_formed" when restoring database in Version 17
Date: Tue, 1 Oct 2024 12:08:58 -0500
Message-ID: <[email protected]> (raw)

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

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: How to handle "could not find function xml_is_well_formed" when restoring database in Version 17
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox