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;
CommentFileSizeAuthor
nodequeue_0.install1.74 KBfragtom

Comments

fragtom’s picture

Title: Bug in installation with postgres schema » Also pager-query in postgres schema doesn't work

fixe pager query in nodequeue.module line 164:

GROUP by nq.qid, nq.size, title 
fragtom’s picture

Title: Also pager-query in postgres schema doesn't work » Error adding new node_queue item - need to create sequence

As described in http://drupal.org/node/27250 the module needs to create sequence:

CREATE SEQUENCE nodequeue_queue_qid_seq INCREMENT 1 START 1; 
merlinofchaos’s picture

Version: » 4.7.x-1.0

Explain 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.

merlinofchaos’s picture

Status: Active » Fixed

This is fixed in 1.1

Anonymous’s picture

Status: Fixed » Closed (fixed)
greggles’s picture

Category: bug » support
Status: Closed (fixed) » Active

don'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.

merlinofchaos’s picture

That's correct. We only use the sequence in postgres.

merlinofchaos’s picture

Status: Active » Closed (fixed)