Primary key constraints - Mailing list pgsql-novice

From Kumar S
Subject Primary key constraints
Date
Msg-id 20050307222756.69905.qmail@web51403.mail.yahoo.com
Whole thread Raw
List 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 by date:

Previous
From: Eduardo Vázquez Rodríguez
Date:
Subject: Re: background jobs
Next
From: "Sean Davis"
Date:
Subject: Re: Primary key constraints