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
PostgreSQL PEAR problem
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 173to read 'LIMIT # OFFSET #' instead of 'LIMIT #, #'.
more reasons
To drop pear for postgres and mssql. but that's only gonna happen after this release.
YEAH!
Quick help, wow, and it worked!
Except for me it was line 559...
Thanks!