Last modified: 2014-11-19 11:54:58 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 25450 - Fix PostgreSQL support for Sematic MW
Fix PostgreSQL support for Sematic MW
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
All All
: Normal trivial (vote)
: ---
Assigned To: Markus Krötzsch
Depends on: 42659
Blocks: postgres
  Show dependency treegraph
Reported: 2010-10-08 11:05 UTC by Thorsten Glaser
Modified: 2014-11-19 11:54 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Thorsten Glaser 2010-10-08 11:05:18 UTC 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.
Comment 1 Niklas Laxström 2010-10-08 11:23:19 UTC
Changing summary. Trolling doesn't help.
Comment 2 John Morton 2011-02-06 16:31:00 UTC
Is that initializer query actually necessary anymore? A fresh install of 1.5.4 seemed to work out of the box for me.
Comment 3 Jeroen De Dauw 2011-02-06 19:44:22 UTC
I'm not sure about that particular query, but all the stuff is currently in the same script, and this script does need to be run in order to use SMW.
Comment 4 MWJames 2014-11-19 11:54:58 UTC
Expected to be solved by [0].


Note You need to log in before you can comment on or make changes to this bug.