https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #13 from Fabien Coelho <[email protected]> 2012-01-14 06:52:36 UTC --- (In reply to comment #12) > There seems to be a way described at > http://archives.postgresql.org/pgsql-general/2004-12/msg01161.php. On any > database smaller than WMF's, I would opt for DROP + ADD, though. Indeed, that is a fun one, just updating the metadata! CREATE TABLE foo(id INT UNIQUE NOT NULL, data TEXT); -- ... UPDATE pg_index SET indisprimary=TRUE WHERE indexrelid=106702; UPDATE pg_constraint SET contype='p' WHERE conname='foo_id_key'; # \d+ foo "foo_id_key" PRIMARY KEY, btree (id) However, you may need an admin to do that, while the add/drop would only require to own the table. > Well, you can also test that :-). Sure. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
