On Sun, 31 Aug 2008 08:40:34 +0300 Timo Sirainen tss@iki.fi 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.:
(root@localhost) [test]> CREATE TABLE where (when TIMESTAMP);
Query OK, 0 rows affected (0.18 sec)
(root@localhost) [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 rain@bluecherry.net