Re: db_restore and xml data

Поиск
Список
Период
Сортировка
От Shahbaz A. Tyagi
Тема Re: db_restore and xml data
Дата
Msg-id 04F0B65A2D3C4DE0BDE8A059482F0110@dxb.sphere.ae
обсуждение исходный текст
Ответ на Re: db_restore and xml data  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: db_restore and xml data
Следующее
От: Sim Zacks
Дата:
Сообщение: Re: when to use "execute" in plpgsql?