https://bugzilla.wikimedia.org/show_bug.cgi?id=25450
Summary: Fix the ridiculous PostgreSQL support
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: trivial
Priority: Normal
Component: Semantic MediaWiki
AssignedTo: mar...@semantic-mediawiki.org
ReportedBy: t.gla...@tarent.de
CC: jeroen_ded...@yahoo.com
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.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
