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.

Reply via email to