Re: SEQ column
Paul J Stevens <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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 >[email protected] >http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Verzonden van mijn Android telefoon met K-9 Mail. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail