On Sun, 31 Aug 2008 08:40:34 +0300
Timo Sirainen <[EMAIL PROTECTED]> wrote:
> How were you able to create a "when" column? I only get syntax error
> if I try to do that.
Just FYI, it's possible to use reserved words as column/table names in
MySQL by quoting them with backticks, e.g.:
([EMAIL PROTECTED]) [test]> CREATE TABLE `where` (`when` TIMESTAMP);
Query OK, 0 rows affected (0.18 sec)
([EMAIL PROTECTED]) [test]> SELECT * FROM `where`;
Empty set (0.00 sec)
The quoting isn't standard, though, and varies between DB backends. I
know that MySQL uses backticks (`foo`), PostgreSQL uses double quotes
("foo"), and MS's DB products use square brackets ([foo]).
It's probably not worth the trouble to have dovecot escape them as long
as it's possible to quote items this way in the config file.
--
Ben Winslow <[EMAIL PROTECTED]>
