Re: db_restore and xml data

From: "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, <pgsql-general(at)postgresql(dot)org>
Cc: "'Enrico Sirola'" <enrico(dot)sirola(at)gmail(dot)com>
Subject: Re: db_restore and xml data
Date: 2009-03-01 12:39:39
Message-ID: 04F0B65A2D3C4DE0BDE8A059482F0110@dxb.sphere.ae
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Peter Eisentraut
Sent: Sunday, March 01, 2009 3:06 PM
To: pgsql-general(at)postgresql(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2009-03-01 14:35:21 Re: when to use "execute" in plpgsql?
Previous Message Peter Eisentraut 2009-03-01 11:06:12 Re: db_restore and xml data