"Greg Sabino Mullane" <greg@xxxxxxxxxxxx> writes: > This seems to indicate it's the xtmp_changed_ids INDEX that > already exists, not the xtmp_changed_ids TABLE. Oh, of course: he's got this: CREATE TABLE xtmp_changed_ids ... CONSTRAINT xtmp_changed_ids PRIMARY KEY (seq_all) so he's trying to force the pkey index to have the same name as the table. Doesn't work. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general