PostgreSQL incompatibility: for SELECT DISTINCT, ORDER BY fields must be a select field in PostgreSQL [#1301602]

I'm getting a PostgreSQL error in the logs from linkintel every time cron runs. The problem is that for a SELECT DISTINCT, PostgreSQL requires that ORDER BY fields also be specified as a SELECT Field. Patch to follow.

Comment	File	Size	Author
#1	PostgreSQL_compatibility_fix-1301602-1.patch	827 bytes	ben coleman

Comments

Comment #1

ben coleman commented 6 October 2011 at 17:15

Status:

Active

» Needs review

Status	File	Size
new	PostgreSQL_compatibility_fix-1301602-1.patch	827 bytes

Attached is a patch for the above problem. This should be compatible with both MySQL and PostgreSQL.

PostgreSQL incompatibility: for SELECT DISTINCT, ORDER BY fields must be a select field in PostgreSQL

Comments

Comment #1

News items

Our community

Documentation

Drupal code base

Governance of community