Wikimedia Bugzilla is closed!

http://semantic-mediawiki.org/wiki/PostgreSQL says:

select max(smw_id) from smw_ids;    -- get value
alter sequence smw_ids_smw_id_seq restart with x + 1  -- value from select above, add 1


You can do it like this, in the code, programmatically, instead:

SELECT setval('smw_ids_smw_id_seq', (SELECT max(smw_id)+1 FROM smw_ids));


We (FusionForge and Evolvis) use PostgreSQL exclusively, as MySQL is not a database. There may be interest in integrating SMW by my employer, which will involve me packaging it for Debian.