Re: Encoding problems in PostgreSQL with XML data

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Encoding problems in PostgreSQL with XML data
Date: 2004-01-09 19:21:50
Message-ID: 1073676109.1521.18.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Rewriting the <?xml?> declaration seems like a workable solution, but it
> would break the transparency of the client/server encoding conversion.
> Also, some people might dislike that their documents are being changed
> as they are stored.

I presume that the XML type stores the textual representation of the XML
rather than a binary (parsed) format?

I say we treat XML the same was as we deal with things like float and
allow some play with the stored object so long as it's reasonably small
and has the same final interpretation.

If they wanted non-mutable text, they would not have declared it as a
structured format. Just like if they don't want leading 0's removed from
numeric input, they don't declare it as numeric but as binary.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2004-01-09 20:04:11 Re: Encoding problems in PostgreSQL with XML data
Previous Message Andreas Pflug 2004-01-09 19:06:45 Re: OLE DB driver