Re: pg_dump problems

Now I'm getting weirder things. I did a pg_dump with -d option and the
dump adds strange caracters:

ERROR: error de sintaxis en o cerca de «I»
LÍNEA 1: I^NSERT INTO objeto_datos_rep VALUES (1172339, 387943, 'Wilde...

Could it be binary corruption (pg_dump for example)?

2011/3/23 Vick Khera <vivek(at)khera(dot)org>:
> 2011/3/23 Martín Marqués <martin(dot)marques(at)gmail(dot)com>:
>> The scenario is like this. I tried today to dump a DB from our
>> production server to load on our development server and got some
>> errors, which I show below.
>
>
> Try using the pg_dump from the 8.4 install to create your dump file.

I'll try this.

> Also make sure your 8.3 installation doesn't have a non-default bytea
> encoding setting (not sure when that setting was introduced, so there
> may not even be such a setting).

bytea has encoding? I thought it was plain binary data.

--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador