PostgreSQL compatability?

2 replies [Last post]
vector84
Offline
Joined: 04/01/2010
Status: 
Answered

Hi there...

Figured I'd toss this out there - just tried to install your modules on a Drupal 6 installation running on PostgreSQL and quickly came up with a handful of errors - database queries 'INSERT INTO' using SET in ms_affiliates.module:949, ms_affiliate.install:17, ms_membership.module:1001, and ms_paypal_api.module:393

Replacing these with appropriate queries using VALUES seems to be working so far though :)

vector84
Offline
Joined: 04/01/2010
And another minor problem

And another minor problem getting this stuff going on PostgreSQL:

This actually applies to the Membership Suite but.... db_affected_rows() returns 0 in PstgreSQL after SELECT... that makes several other things fail on a PostgreSQL install...

So far I haven't had any trouble replacing those checks with a null check on the $result they are supposed to check
ie 'if ($result)' instead of 'if (db_affected_rows())'

Leighton Whiting
Offline
Joined: 06/02/2009
Vector, Thanks for posting

Vector,
Thanks for posting those, I'll see if I can make the next release more PostgreSQL friendly.

-Leighton

Twitter Feed