PostgreSQL Compatability for workspace.module

ken-ichi - July 4, 2005 - 17:26
Project:Workspace
Version:4.6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Frank Ralf
Status:closed
Description

PostgreSQL has two minor quibbles with the SQL in the Workspace: it doesn't like double quotes in queries, and it apparently wants JOIN syntax to immediately follow the joined table in the FROM clause, not simply anywhere after the FROM clause. I've attached a patch, which works with Drupal 4.6, PostgreSQL 8, Apache 1.3, PHP 4.3.10. I haven't tested it with MySQL yet.

AttachmentSize
workspace_pgsql.patch1.06 KB

#1

mrice16453 - June 21, 2006 - 15:59

Hi all,

I implemented a very simliar change to get it to work on my site with Drupal 4.7.2 and PostgreSQL 8.1.4. I downloaded the http://ftp.osuosl.org/pub/drupal/files/projects/workspace-4.7.0.tar.gz and workspace-cvs.tar.gz this morning. Neither of them had this change applied.

I'm reasonably sure that this will work with MySQL, has anyone tested?

What will it take to make this part of the distro?

#2

Frank Ralf - July 14, 2009 - 14:50
Assigned to:Anonymous» Frank Ralf
Status:active» closed

Pertains to an outdated version. Please create new issue if problem persists.

TIA
Frank

 
 

Drupal is a registered trademark of Dries Buytaert.