The Search filter builds a query which may contain WHERE (node.status <> 0) AND (0).
Postgresql needs type boolean instead of integer at this point like WHERE (node.status <> 0) AND (FALSE).

CommentFileSizeAuthor
#1 views-629840.patch537 bytesfuerst

Comments

fuerst’s picture

fuerst commented
Status: Active » Needs review
StatusFileSize
new views-629840.patch537 bytes

The attached patch fixes this.

fuerst’s picture

fuerst commented
Title: Search filter broekn with Postgresql » Search filter broken with PostgreSQL

Corrected typo in the issue title

merlinofchaos’s picture

merlinofchaos commented
Status: Needs review » Fixed

Committed to all branches. THanks!

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

Automatically closed -- issue fixed for 2 weeks with no activity.

Issue tags: +PostgreSQL

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.