Confirmed fixed. Very, very nice (although still room for
improvement...indexed search will be great, one day).
Michael
Paul J Stevens wrote:
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
