Eric Faulhaber <ecf@goldencode.com> writes:
> OK, but this particular issue is something quite new to the latest
> version.
Again, PG has never stored such data correctly.
> Am I stuck at 8.1.3 for the time being? I'd be happy to create a patch
> to resolve this for a future version, but if it is not considered a
> defect, it doesn't make sense for me to do that.
It's not a defect ... or at least, it doesn't make sense to change it
unless you are willing to go through the entire system to make it able
to store null bytes in text. We've looked at that in the past and
always concluded that it was completely impractical :-(
regards, tom lane