On 24/05/11 18:58, Jasmin Dizdarevic wrote:
> Alright, I've misunderstood this issue. Do you have to escape bytea
> columns during export or import? And how you would do this?
Some database drivers and some apps don't understand the new hex output
format for bytea columns.
IIRC, the format change
Alright, I've misunderstood this issue. Do you have to escape bytea columns
during export or import? And how you would do this?
Ty
2011/5/24 Craig Ringer
> On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote:
> > We had trbls with our drupal site, because some settings are stored in
> bytea c
On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote:
> We had trbls with our drupal site, because some settings are stored in bytea
> columns. I think lobs are a problem too, but pls see the pg_dump docs for
> details.
Is it possible that you are referring to the `bytea_output' setting in
Postg
On 23/05/2011 11:19 PM, jasmin.dizdare...@gmail.com wrote:
Just be careful with pg_dump, if you have binary data stored in your 8.4 db. In
default mode it just export text.
Er ... what?
Can you elaborate on that?
Do you mean large objects? bytea fields? Something else?
--
Craig Ringer
Tech
Baumanis
Cc:
Subject: Re: [SQL] Which version of PostgreSQL should I use.
Just thought I would update this myself.
Last night I managed to have a chat with some people about this on IRC.
Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have a
Just thought I would update this myself.
Last night I managed to have a chat with some people about this on IRC.
Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have always used
UTF-8 for encoding, too.
So the changes from 8.4 don't seem to be o
> We're currently using psql 8.1 and are on the way to upgrading to 8.4.
The tools "pg_dump" & "pg_restore" are used to extract and re-create databases.
Can be used for chores such as deploying from development to production,
backing up, and upgrading.
http://www.postgresql.org/docs/current/stat
