-----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@xxxxxxxxxxxx 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
