[Dovecot] expire plugin: columns not uniq

Steffen Kaiser skdovecot at smail.inf.fh-brs.de
Fri Aug 21 11:48:42 EEST 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 19 Aug 2009, Nikita Koshikov wrote:

> How can I solve this ? and why expire plugin is trying to use INSERT, instead of UPDATE ?

Search the Wiki about Postgres and the requirement of a TRIGGER.
I guess that sqlite requires something like this.

Unfortunately, there is no UPDATE OR INSERT in SQL and it is hard to 
simulate.

Bye,

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQEVAwUBSo5fbnWSIuGy1ktrAQKQdQgAs1fioq/x86JNb9L7SvGnU9wPOUICilsI
RcY+PrsMzGxdRShlnDhEIJGRlbzr7jHDhDhMfej+TGP9XqBFPqBphVxT8JIJmGXz
Z4qEvwLoyuSKxWikLxVLaslDPYPu2tjmvKt+HWaLgev7ecwFF8NoKBHhWV6fR3x9
o/xVVcj6hM38SkiGc6+t27OC5ch6Tq5Vqmau4QIB7fkN8bA8IoBU17rM0eW4k80m
7nKTVsPqFcDKlmes2d5vJVlCYg+NCy69RVIZEFQwOJahBjveSvJsXWnhks9e0nEk
PmtMPMUFHOvfe+4KfK2GFxAPCznOSrxfgMuUewXnENCgLtXrox+zPA==
=8vpx
-----END PGP SIGNATURE-----


More information about the dovecot mailing list