> So I renamed all sequences: > ALTER TABLE alias_idnr_seq RENAME TO dbmail_alias_idnr_seq; > ALTER TABLE user_idnr_seq RENAME TO dbmail_user_idnr_seq; > ALTER TABLE mailbox_idnr_seq RENAME TO dbmail_mailbox_idnr_seq; > ALTER TABLE physmessage_id_seq RENAME TO dbmail_physmessage_id_seq; > ALTER TABLE message_idnr_seq RENAME TO dbmail_message_idnr_seq; > ALTER TABLE messageblk_idnr_seq RENAME TO dbmail_messageblk_idnr_seq; > ALTER TABLE seq_pbsp_id RENAME TO dbmail_seq_pbsp_id; > > When I try to copy a message using IMAP I get: > Aug 14 23:20:28 geht-schon dbmail/imap4d[14333]: dbpgsql.c, db_query: > Error executing query [INSERT INTO dbmail_messages > (mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag, > flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT '12', > physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, > recent_flag, draft_flag, '240a61ab17e793b2b5137f879e12a7bf', status FROM > dbmail_messages WHERE message_idnr = '166659'] : [ERROR: relation > "message_idnr_seq" does not exist ] > > So I have to rename some sequences? Strange ...
I believe the problem is that some tables have default values that still reference the old name of the sequence. So you need to add a few alter table commands that change the defautl values for those columns.
