[Dovecot] expire plugin: columns not uniq

Nikita Koshikov koshikov at gmail.com
Fri Aug 21 16:19:10 EEST 2009


On Fri, 21 Aug 2009 10:48:42 +0200 (CEST)
Steffen Kaiser <skdovecot at smail.inf.fh-brs.de> wrote:

> -----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.
>
Thank for your answer.
I'll dig in this direction.
 
> Unfortunately, there is no UPDATE OR INSERT in SQL and it is hard to 
> simulate.

You mean in dovecot expire plugin or where ?

> 
> 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