Re: Which version of PostgreSQL should I use.
| От | Jasmin Dizdarevic |
|---|---|
| Тема | Re: Which version of PostgreSQL should I use. |
| Дата | |
| Msg-id | BANLkTimMyHpZp0F0AX5RDFqTHRA_tChfrA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Which version of PostgreSQL should I use. (Craig Ringer <craig@postnewspapers.com.au>) |
| Ответы |
Re: Which version of PostgreSQL should I use.
|
| Список | pgsql-sql |
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 <craig@postnewspapers.com.au>
On 24/05/11 14:30, jasmin.dizdarevic@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
PostgreSQL 8.4 and above?
If so, the issue isn't that pg_dump somehow fails to dump the bytea
data. Rather, it's that drupal doesn't deal well with bytea data from
newer versions of PostgreSQL until the bytea_output setting is changed
to 'escape' because it doesn't understand the new hex format.
--
Craig Ringer
В списке pgsql-sql по дате отправления: