It is used to track changes, like a mailbox version. The new imap features use
those. If you modify the state of a mailbox, you need to bump the version.
Andrea Brancatelli <abrancate...@schema31.it> schreef op 6 februari 2015
09:24:48 CET:
>Can anyone spend a few words for me on the new "seq" column?
>
>What's it's main purpose?
>
>Is it functionally relevant or it something like a cache that can be
>reset, modified or whatever with no big issues?
>
>I'm used to move messages between mailboxes with queries like UPDATE
>dbmail_messages SET mailbox_idnr = 89 WHERE mailbox_idnr = 47981; but
>the seq column would be no more monotonically increasing in such case.
>Is it a problem?
>
>Futhermore in a dual master scenario the column doesn't seem really
>replication-aware, so I was curious if having duplicates in it may be
>problematic.
>
>Thanks.
>
>--
>*Andrea Brancatelli
>
>Schema31 S.p.a.
>Responsabile IT*
>
>ROMA - FIRENZE - PALERMO
>ITALY
>Tel: +39.06.98358472
>Cell: +39.331.2488468
>Fax: +39.055.71880466
>Società del gruppo SC31 ITALIA
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>DBmail mailing list
>DBmail@dbmail.org
>http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
--
Verzonden van mijn Android telefoon met K-9 Mail.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
