There's four queries in spaces.module that have bad quoting, which may work in mysql, but certainly does not in Postgres (double quotes being used to escape column names).
$result = db_query('SELECT id, value FROM {spaces_features} WHERE sid = %d AND type = "%s" ORDER BY weight ASC', $sid, $type);
$result = db_query('SELECT id, value FROM {spaces_settings} WHERE sid = %d AND type = "%s"', $sid, $type);
db_query('INSERT INTO {spaces_features} (sid, type, id, value, weight) VALUES (%d, "%s", "%s", "%s", %d)', $values);
db_query('INSERT INTO {spaces_settings} (sid, type, id, value) VALUES (%d, "%s", "%s", "%s")', $values);
In all cases, those single and double quotes should be swapped. The other queries in the module are fine. This appears in the 1.x branch as well, which is where I originally noticed it.
I'd roll a patch, but I quickly went down a rabbit hole trying to sync up the dev versions of context and spaces.
Comments
Comment #1
yhahn commentedThanks! I've committed fixes to both branches -- let me know if this works for you on Postgres.
http://drupal.org/cvs?commit=193684
Comment #2
stormsweeper commentedI've made manual edits to the 1.0-alpha4 release and it seems to be working fine. I unfortunately don't have the time to try to muck about with the 2.0 alphas just now.
Comment #3
yhahn commentedClosing for now.