Sergey Spiridonov wrote:

Seems to be postgresql problem. This query is used in 3 places:
2 times in dbmsgbuf.c and 1 time in dbsearch.c. I changed them and till now everything works fine...

# postgres --version
postgres (PostgreSQL) 7.3.6

This query is a good candidate for being replaced then. Strange that PostgreSQL's query planner doesn't do this right...

Since the query will also work in MySQL I'll change it (unless anybody has any good reason for not doing it.)

Ilja



--
Ilja Booij
IC&S B.V.

Stadhouderslaan 57
3583 JD  Utrecht
www.ic-s.nl

T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]

Reply via email to