Author: t.glaser

Description:
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.

Version: unspecified
Severity: trivial