Primary key constraints

Поиск
Список
Период
Сортировка
От Kumar S
Тема Primary key constraints
Дата
Msg-id 20050307222756.69905.qmail@web51403.mail.yahoo.com
обсуждение исходный текст
Список pgsql-novice
Hi group,


I removed a table from db names experiment.
It has a primary key exp_id (experiment_exp_id_seq)

I renamed that table to study. I re-created experiment
table with all new column names.  exp_id
(experiment_exp_id_seq) remains the primary key for
this table.

Now when I try to execute this table I get the
following error:

psql:/home/db/experiment.sql:10: ERROR:  relation
"experiment_exp_id_seq" already exists


How to remove this key from every where from the whole
db.

Thank you.

K




__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

В списке pgsql-novice по дате отправления:

Предыдущее
От: Eduardo Vázquez Rodríguez
Дата:
Сообщение: Re: background jobs
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: Primary key constraints