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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Peter Eisentraut Sent: Sunday, March 01, 2009 3:06 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Enrico Sirola Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general