On Wed, 2005-03-16 at 13:15 -0500, Matthew T. O'Connor wrote: > 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.
That's why there's no constraint on them. FWIW: Only with Pg have I ever noticed this kind of ``optimization'' actually help anything. -- Internet Connection High Quality Web Hosting http://www.internetconnection.net/
