A little bug DB_active_rec.php function _compile_select for postgresql

[eluser]James Gifford[/eluser]
I just switched to the final 1.6.0 release and I have also noticed an error with queries using a PostgreSQL database.

CI is now putting parentheses around the tables in the FROM clause like this:

Code:

SELECT * FROM ("posts") ORDER BY "date_created" LIMIT 20

The parenthesis don't seem to be proper Postgres syntax as the query will work fine without them. Also, I don't remember CI putting quotes around the field names before, but this is not causing problems with the query.

EDIT:
Changing line 489 in postgre_driver.php from this:

Code:

return '('.implode(', ', $tables).')';

to this:

Code:

return implode(', ', $tables);

fixed the problem.