Author: wwwwolf
Description:
Hello, I tested Semantic MediaWiki extension on PostgreSQL (both 1.1.1 and yesterday's svn version). Here's what went wrong.
I tried creating page Property:Population with content "[[has type::number]]". It apparently performed this query...
INSERT INTO smw_specialprops (subject_id,subject_namespace,subject_title,property_id,value_string) VALUES ('556','102','Population','1','_num');...and it got back this response:
ERROR: column "subject_title" of relation "smw_specialprops" does not exist
...which appears to be true. Is the PostgreSQL schema in sync with the MySQL schema?
Viewing *any* Property namespace pages seems to not work. For Property:Population, it appears to perform this query:
SELECT DISTINCT subject_id FROM smw_relations WHERE relation_title='Population' ORDER BY subject_title LIMIT 26;
PostgreSQL thinks this is bad form:
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Not sure how much these help, but since the SMW developers asked for comments on how SMW works on PostgreSQL, I thought I'd submit my findings. Basically, I can browse articles and see their infoboxes, but viewing and editing property pages doesn't work, making the extension pretty useless at the moment. But we live in hope!
Version: unspecified
Severity: normal
OS: Linux
Platform: PC