ERROR: relation "xxx" already exists but where???? - Mailing list pgsql-general

From Joost Kraaijeveld
Subject ERROR: relation "xxx" already exists but where????
Date
Msg-id A3D1526C98B7C1409A687E0943EAC41060602D@obelix.askesis.nl
Whole thread Raw
Responses Re: ERROR: relation "xxx" already exists but where????
List pgsql-general
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 TABLE / ADD PRIMARY KEY will create implicit index "case_histories_pkey" for table "case_histories"

ERROR: relation "case_histories_pkey" already exists
SQL state: 42P07

The table does not have this key. Assuming that the response is correct, where can I find and/or delete this relation?
Ihave deleted an entry inpg_constraint with that name but that did not do the trick 

TIA

Joost

Joost


pgsql-general by date:

Previous
From: "Livia Santos"
Date:
Subject: Table description
Next
From: "Scott Marlowe"
Date:
Subject: Re: ERROR: relation "xxx" already exists but where????