Re: pg_restore error

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?

You can create a table with a primary key like so

CREATE TABLE test (
id int,
PRIMARY KEY (id)
);