Aaron Stone wrote:
On Tue, 2007-01-02 at 13:15 +0900, Tommi Lätti wrote:
Allrighty, I could check that with tcpdump maybe but I think I can
assume that it's now bytea... although the schema says text.
Well, if the schema says text, then the bytea conversion has not taken
Is there a way to tell from the data if the bytea conversion has taken
place already? When I look at the pgsql documentation, I think the text
should have quite a lot of escapes there. The data I have seems to have
\012's and so.
place. If you have a backup, carefully renamed to avoid the default name
I have now multiple snapshots. Not going to do the same little mistake
again...
of backing up again... run the conversion script. You might want to
break the script into two parts, first the bytea conversion and then the
schema changes.
I just did the script again, line by line manually. No problems nor any
errors during the script. Bytea seemed to go thru just well also, but I
can't tell if there's any difference in the data in the messageblocks
themselves.
--
br,
Tommi
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
