Re: db_restore and xml data - Mailing list pgsql-general

From Shahbaz A. Tyagi
Subject Re: db_restore and xml data
Date
Msg-id 04F0B65A2D3C4DE0BDE8A059482F0110@dxb.sphere.ae
Whole thread Raw
In response to Re: db_restore and xml data  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
The problem is sorted out, as it was in 2003 server and when we were
comparing it with XP one.

Thanks,

Shahbaz A. Tyagi

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Peter Eisentraut
Sent: Sunday, March 01, 2009 3:06 PM
To: pgsql-general@postgresql.org
Cc: Enrico Sirola
Subject: Re: [GENERAL] db_restore and xml data

On Friday 27 February 2009 19:09:57 Enrico Sirola wrote:
> Hello,
> I have a pgsql database hosting xml data in xml columns. The data,
> have <!DOCTYPE> declarations at the beginning, so it is saved with
>
> XMLPARSE (DOCUMENT <text>)
>
> when I try to restore a database from dump, pg_restore complains
> because the data it tries to restore is not an xml content

Please give us a concrete, reproducible test case.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: db_restore and xml data
Next
From: Sim Zacks
Date:
Subject: Re: when to use "execute" in plpgsql?