Michael Ritchie wrote:
> Paul,
>
> I've just update to svn 2196, on postgresql 8.4.1, with the aim of
> speeding up searches. But, now I errors with the new search code. Level
> 5 log follows.
>
I forgot the GROUP BY clause. Fixed now.
> Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
> dbpgsql.c,db_query: executing query [SELECT m.message_idnr,k.messageblk
> FROM dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id
> = p.id JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE
> mailbox_idnr = '9' AND status IN ('0','1' ) AND k.is_header = '0' HAVING
> ENCODE(k.messageblk::bytea,'escape') ILIKE '%Cuculowskyj%']
> Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Error dbpgsql.c,
> db_query: Error executing query [SELECT m.message_idnr,k.messageblk FROM
> dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id =
> p.id JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE
> mailbox_idnr = '9' AND status IN ('0','1' ) AND k.is_header = '0' HAVING
> ENCODE(k.messageblk::bytea,'escape') ILIKE '%Cuculowskyj%'] : [ERROR:
> column "m.message_idnr" must appear in the GROUP BY clause or be used in
> an aggregate function ]
Too weird though. Apparently postgres 8.0.4 on debian doesn't need it
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
