Error SQL postgresql

Fixed in 5.x-2.x-dev and 6.x-1.x-dev.

This is NOT fixed in 6.x-1.x-dev. Not even close.

The following MySQL-specific features (among others) cannot be used in PostgreSQL:

• Table aliases in DELETE or UPDATE statements (only in SELECTs)
• JOINs in DELETE or UPDATE statements (only in SELECTs)
• ISNULL function (the right syntax is “…WHERE td.tid IS NULL”)

Building a DELETE query for data that is selected by join would be rather complicated and end up using PostgreSQL-specific code; better way would be to run “SELECT ta.tid FROM {term_access} ta LEFT JOIN {term_data} td ON ta.tid = td.tid WHERE ta.tid <> 0 AND td.tid IS NULL” and then use the result set of that query in a foreach loop that deletes the relevant rows.

The problematic function is taxonomy_access_enable().

OK, here is a patch that really squashes this bug.

Note that this could still be better because it might work on all DBs, but I don't currently have any MySQL setup to test it on, so I left the MySQL code as it is, as I didn't want to break anything.

Thanks.

http://drupal.org/cvs?commit=211860

Phew, you had actually noticed that I had forgotten my table prefixes into the patch! I only realised it now, after you'd already committed it. Thanks for fixing that!