On Mon, 2005-03-28 at 18:46, Paul J Stevens wrote: > Colin Manning wrote: > > Hi All, > > > > I have been running dbmail 1.2.10 (pg 7.3.4-11) for a while now, but the > > machine I am running on is getting flaky, so I want to upgrade the > > hardware. I thought I'd update to dbmail 2.0.4 (pg 7.3.4-11) at the same > > time. > > --Snip-- > So your 1.2 tables were not quite standard. In that case all bets are of > regarding the migration script. I'm guessing you may have experimented with > the > auto_notify or auto_reply feature some time in the past, and may have created > an > foreign key constraint from either of those on the user_id_idx index. > > try diffing you 1.2 schema with the stock 1.2 schema: > > createdb db1_stock > psql db1_stock < dbmail-1.2.11/sql/postgresql/create_tables.pgsql > pg_dump -s dbmail > /tmp/dbmail.sql > pg_dump -s db1_stock > /tmp/db1_stock.sql > diff -u /tmp/dbmail.sql /tmp/db1_stock.sql > > etc.... Yep. Looks like I don't have stock schema, however I don't recall setting up anything special.
I just removed the relevant CREATE INDEX lines from my dump file and the relevant DROP INDEX lines from the migrate script. As nothing happened to the database between these steps I don't think anything bad can come of this. -- Regards, Colin Manning B.Sc. Systems Consultant I.T. Navigate Pty Ltd Phone: (08) 9574 0200 Mobile: 0412 384 242 ABN: 61 108 296 288
