[TYPO3-core] indexed_search breaks on PostgreSQL

Karsten Dambekalns karsten at typo3.org
Fri Nov 10 18:44:57 CET 2006


Hi.

On 09.11.2006, at 12:31, Martin Kutschker wrote:
> To resolve this someone added ALL columns of index_phash to the SELECT
> clause. That is all but one: freeIndexSetId.

That someone was probably me, back in 2004 possibly... I guess the  
field was added later, because I am sure it worked with PostgreSQL  
back then.

> For 4.0 I suggest to add freeIndexSetId to GROUP BY. This works  
> fine on
> PostgreSQL and the indexed search works again.

+1, this is not breaking anything else by definition.


Regards,
Karsten
-- 
Karsten Dambekalns
Gimme Five!
http://typo3.org/gimmefive


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 304 bytes
Desc: This is a digitally signed message part
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20061110/8165a019/attachment.pgp 


More information about the TYPO3-team-core mailing list