Error while converting to PostgreSQL
Posted: Fri May 16, 2008 7:23 pm
While trying to convert my database (about 75% of the way through), I got a message that says
"Error creating index - hand_histories_idx_01
7 - SQLstate = 23505
ERROR: Could not create unique index
Table contains duplicated values.;
Error while executing the query"
What do I do?
EDIT: While I'm thinking about it, while installing postgreSQL it said that port 5432 was already being used, so I changed it to port 5433, and changed the port again in postgreSQL settings to 5433. The beginning of the conversion went ok, but if this is a problem, let me know.
"Error creating index - hand_histories_idx_01
7 - SQLstate = 23505
ERROR: Could not create unique index
Table contains duplicated values.;
Error while executing the query"
What do I do?
EDIT: While I'm thinking about it, while installing postgreSQL it said that port 5432 was already being used, so I changed it to port 5433, and changed the port again in postgreSQL settings to 5433. The beginning of the conversion went ok, but if this is a problem, let me know.