The installation in postgres schema doesn't work, use in nodequeue.install following ddl-statements:
case 'pgsql':
db_query("CREATE TABLE {nodequeue_queue} (
qid int4 NOT NULL PRIMARY KEY,
title varchar(255) NOT NULL,
size int4 default '0'
)");
db_query("CREATE TABLE {nodequeue_roles} (
qid int4 NOT NULL,
rid int4
)");
db_query("CREATE TABLE {nodequeue_types} (
qid int4 NOT NULL,
type varchar(255)
)");
db_query("CREATE TABLE {nodequeue_nodes} (
qid int4 NOT NULL,
nid int4,
position int4
)");
$success = TRUE;
break;
| Comment | File | Size | Author |
|---|---|---|---|
| nodequeue_0.install | 1.74 KB | fragtom |
Comments
Comment #1
fragtom commentedfixe pager query in nodequeue.module line 164:
Comment #2
fragtom commentedAs described in http://drupal.org/node/27250 the module needs to create sequence:
Comment #3
merlinofchaos commentedExplain to me why use int4 over integer? The rest of Drupal uses integer -- I'd prefer to be consistent with Drupal's db in that instance.
Comment #4
merlinofchaos commentedThis is fixed in 1.1
Comment #5
(not verified) commentedComment #6
gregglesdon't we need to use the {sequence} table for mysql?
I'm asking because I don't really know. All I know is that the create sequence failed on our mysql server and I noticed that the only call to create sequence in core seems to be for pgsql.
Comment #7
merlinofchaos commentedThat's correct. We only use the sequence in postgres.
Comment #8
merlinofchaos commented