Re: add primary key doesn't block?

On Thu, Jan 21, 2010 at 12:45 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
>> When we perform a test migration of the data we found some errors on
>> the logs, one of them is this one:
>
>> """
>> mic=# ALTER TABLE tcom_invitacion ADD primary key (id_invitacion);
>> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
>> "tcom_invitacion_pkey" for table "tcom_invitacion"
>> ERROR:  concurrent insert in progress
>> """
>
> Can you provide a reproducible test case?
>

trying to do so, gives me an error when moving the affected table from
the migration test database to my machine:
"""
ERROR: invalid byte sequence for encoding "UTF8": 0xed6261
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
CONTEXT: COPY tcom_invitacion, line 543881
"""
both servers had client_encoding and server_encoding in UTF8 and if i
try this from the real server i get no error, so i guess this was
somehow network corruption

i failed to say that i make the migration directly via the network:
$PG8.4DIR/bin/pg_dump -C -h ip_old_server dbname | $PG8.4DIR/bin/psql

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157