[GENERAL] ERROR: relation xxx already exists but where????

I managed to drop a table without apparently droppig it's primary key After recreating the table I try to recreate the primary key. If I run the following: ALTER TABLE case_histories ADD CONSTRAINT case_histories_pkey PRIMARY KEY(case_history_id); Postgresql responds with: NOTICE: ALTER

Re: [GENERAL] ERROR: relation xxx already exists but where????

On 8/20/07, Joost Kraaijeveld [EMAIL PROTECTED] wrote: I managed to drop a table without apparently droppig it's primary key After recreating the table I try to recreate the primary key. If I run the following: ALTER TABLE case_histories ADD CONSTRAINT case_histories_pkey PRIMARY