Re: Table both does not and does exist! wth?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> enf=# DROP TABLE IF EXISTS xtmp_changed_ids;
> NOTICE: table "xtmp_changed_ids" does not exist, skipping
> DROP TABLE
> enf=# CREATE TABLE xtmp_changed_ids
> (seq_all SERIAL NOT NULL,
...
> NOTICE: CREATE TABLE will create implicit sequence...
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
>  index "xtmp_changed_ids" for table "xtmp_changed_ids"
> ERROR: relation "xtmp_changed_ids" already exists

This seems to indicate it's the xtmp_changed_ids INDEX that
already exists, not the xtmp_changed_ids TABLE. If it was the
table, we'd presumably see the ERROR appear before the
NOTICE (as the table is created first, and then the indexes).
Thus, make sure you don't have an index named xtmp_changed_ids
somewhere already: \di xtmp_changed_ids

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201012171118
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk0LjWYACgkQvJuQZxSWSsh/tgCgtKx53lBBjcbTR1178t1ZpLJL
JIUAn0giUTyphUX7D0KGDzb1C7bK0nw5
=n8OS
-----END PGP SIGNATURE-----