Geo Carncross wrote:
But watch this:
dbmail=# alter table dbmail_physmessage add column message_idnr BIGINT
NULL;
ALTER TABLE
dbmail=# alter table dbmail_physmessage add column mailbox_idnr BIGINT
NULL;
ALTER TABLE
If I understand this correctly, I don't think you can do this.
dbmail_physmessage can't be directly associated with either a specific
message_idnr, or a specific mailbox_idnr because it might actually be
the physical message behind a number of messages located in a number of
different mailboxes.