I've found an issue located on counter.module line 174:
INSERT IGNORE is not permitted in postgresql.
You can see here how to fix this bug:
http://robbat2.livejournal.com/214267.html
Provisionally on my code I've added the pqsql case but I expect that this is not the correct way to fix it:
case 'pgsql':
$sql = " INSERT INTO {counter} (counter_ip,counter_date,counter_page) ".
" VALUES ('%s','%s','%s') ";
break;
Hope you can fix it soon.
Comments
Comment #1
drupalnesia commentedI will re-check if PostgreSQL doesn't support IGNORE clause, thanks.
Comment #2
drupalnesia commentedComment #3
drupalnesia commented6.x-2.8:
Bug fix: PostgreSQL: emulate INSERT IGNORE
Bug fix: Skip Admin now working
Please help to test because I have no PostgreSQL yet.