Ok, trying Drupal for the first time. I'm using PG 7.3.4, PHP 4.3.2. I want to have potentially several sites in one DB, so I need to use table prefixes. I was a little annoyed that there wasn't a script to do that automatically, but this did it:

$ cat addprefix
#!/usr/bin/perl

while(<>) {
s/(TABLE|INDEX|ON|INTO|SEQUENCE)\s([a-z])/$1 test_$2/g;
print $_;
}

$ ./addprefix < *pgsql | psql drupal

Does that look right?

But, at the top of every page I get:

warning: pg_exec(): Query failed: ERROR: LIMIT #,# syntax not supported.
Use separate LIMIT and OFFSET clauses.
. in /usr/local/lib/php/DB/pgsql.php on line 169.

So, is Drupal CVS simply not working with Postgres right now? What's the deal? I could fix that, but if it's not tested with PG, 10 zillion other things will probably go wrong.

So, simple question: is anyone using Drupal CVS with PG successfully?

Comments

Dries’s picture

warning: pg_exec(): Query failed: ERROR: LIMIT #,# syntax not supported. Use separate LIMIT and OFFSET clauses in /usr/local/lib/php/DB/pgsql.php on line 169.That is PHP's PEAR database abstraction layer not supporting your PostgreSQL version (it has nothing to do with Drupal). I had the same problem and fixed it by editing /usr/local/lib/php/DB/pgsql.php: change line 173
to read 'LIMIT # OFFSET #' instead of 'LIMIT #, #'.

adrian’s picture

To drop pear for postgres and mssql. but that's only gonna happen after this release.

yodermk’s picture

Quick help, wow, and it worked!

Except for me it was line 559...

Thanks!