Posted by mustafau on February 16, 2008 at 3:05am
| Project: | Job queue |
| Version: | 5.x-3.0 |
| Component: | Code |
| Category: | feature request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (won't fix) |
Issue Summary
I can not create patches, so I am putting this here;
<?php
case 'pgsql':
db_query('CREATE TABLE {job_queue} (
jqid serial,
created int NOT NULL,
description varchar(255) NOT NULL,
function varchar(255) NOT NULL,
arguments text NOT NULL,
file varchar(255) NOT NULL,
priority smallint NOT NULL,
PRIMARY KEY (jqid))');
db_query("CREATE INDEX {job_queue}_priority_jqid_idx ON {job_queue} (priority, jqid)");
db_query('CREATE TABLE {job_queue_functions} (
function varchar(255) NOT NULL,
priority smallint NOT NULL,
PRIMARY KEY (function))');
break;
?>This code worked well on my testing environment.
Comments
#1
The patch file is attached.
#2
The Drupal 6 version is in CVS and, with the help of the improved database API, does support Drupal 6.