On Tuesday 29 November 2005 15:43, A. Kretschmer wrote: >> I got an error when I transferred the data to my Web database >> running MySQL: > >MySQL is a other RDBMS. You can't expect that all features from >PostgreSQL are working with MySQL. > >> ERROR 1062 at line 19839 in file: 'ss_relation_citations.sql': >> Duplicate entry '64062' for key 1 > >My guess: MySQL can't handle inheritance.
No, it doesn't. Therefore, I have a quite different table structure in the MySQL database, and it caught the error because of the very fact that the citation_id is a genuine primary key in the receiving MySQL table. -- Leif Biberg Kristensen | Registered Linux User #338009 http://solumslekt.org/ | Cruising with Gentoo/KDE ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
