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@xxxxxxxxx>: > 2011/3/23 MartÃn MarquÃs <martin.marques@xxxxxxxxx>: >> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
