Michael Monnerie wrote:
> Ups, posted on the wrong list, now on -dev:
>
> SELECT userid FROM dbmail_usermap WHERE 1 = 2
>
> That SELECT should be removed I'd suggest. Or does it have a deeper
> meaning? I just saw it in the logs in this context:
It's there to find out if the table exists or not, without side-effects.
>
> 2009-02-17 09:07:47 CET pid=23780 17/101776 idle: LOG: statement:
> SELECT userid FROM dbmail_usermap WHERE 1 = 2
> 2009-02-17 09:07:47 CET pid=23780 17/101777 idle: LOG: statement:
> SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE
> login in ('[email protected]','ANY') ORDER BY sock_allow, sock_deny
> 2009-02-17 09:07:47 CET pid=23780 17/101778 idle: LOG: statement:
> SELECT user_idnr FROM dbmail_users WHERE lower(userid) =
> lower('[email protected]')
> 2009-02-17 09:07:47 CET pid=23780 17/101779 idle: LOG: statement:
> SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE
> user_idnr = 152
> 2009-02-17 09:07:47 CET pid=23780 17/101780 idle: LOG: statement:
> UPDATE dbmail_users SET last_login = '2009-02-17 09:07:47' WHERE
> user_idnr = 152
>
> mfg zmi
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Dbmail-dev mailing list
> [email protected]
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
