Re: pg_restore error

At 13:38 +0100 10/10/2002, Adam Witney wrote:
>On 10/10/02 1:25 pm, "pascal bérest" <lists(at)magnetophone(dot)com> wrote:
>
>>> Are you sure the synd_article table and cable_id_cable_seq sequence aren't
>>> already in the database?
>>
>> yes, there are existing.
>>
>>> Presumably your dump file contains the create statements for these two
>>> objects and so the pg_restore is trying to create them.
>>>
>>> How did you create the dump file? The -a switch will allow you to dump only
>>> the data if that's what you need. Looks like you may be dumping the schema
>>> as well
>>
>> I tried with the -a option, and it was quite the same.
>> I just tried to delete the synd_article_pkey then restore the table
>> synd_article, but it didn't recreate the keys as they were. and i
>> don't know how to do that (as i am using mysql for my other projects
>> and that it seams to be more simple).
>>
>
>What happened when you tried the -a option?

i have quite the same error. i have a message telling that the key
can't be duplicate. i suppose that as the id is already existing, it
can't duplicate it, as in mysql.

>You can create a table with a primary key like so
>
>CREATE TABLE test (
> id int,
> PRIMARY KEY (id)
>);

yep, but is a way to create a primary key when the table already exists ?

thanx,
pascal.
--

http://www.magnetophone.com