SEQ column

Andrea Brancatelli <[email protected]>
Newsgroups gmane.mail.imap.dbmail
Organization Schema31 S.p.a.
Message-ID <[email protected]>
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
abrancatelli.vcf (text/x-vcard, 324 B)
begin:vcard
fn:Andrea Brancatelli  
n:Brancatelli;Andrea
org:Schema31 S.p.a.
adr:;;Via Giovanni Andrea Badoero, 67;Roma;RM;00154;Italia
email;internet:[email protected]
title:Responsabile IT
tel;work:+39-06-98358472
tel;fax:+39-055-71880466
tel;cell:+39-331-2488468
url:http://www.schema31.it/
version:2.1
end:vcard
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.