Re: Table both does not and does exist! wth? - Mailing list pgsql-general

"Greg Sabino Mullane" <greg@turnstep.com> 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