Table has duplicate keys, what did I do
От | John Gateley |
---|---|
Тема | Table has duplicate keys, what did I do |
Дата | |
Msg-id | 20080128160402.2101f41f.gateley@jriver.com обсуждение исходный текст |
Ответы |
Re: Table has duplicate keys, what did I do
Re: Table has duplicate keys, what did I do |
Список | pgsql-general |
Somehow I have managed to have two tables with duplicate keys. In both tables, the key is an integer, filled from a sequence. There is only 1 duplicated entry in each table: in the first table, there are two ID "1"s, and in the second table there are two ID "123456"s (the second table entry is linked to the first table's ID 1). I noticed this because a pg_dump followed by a psql < dumpfile will not reload. I've figured out a fix: a script that cleans the dump file, removing the two duplicate lines (leaving the original). But, mostly, I'm wondering how I managed to get in this state, if it was something I did, or perhaps caused by killing the postmaster the wrong way (I don't think I ever did this, but maybe), or a crash. I did do a brief search, didn't find anything seemingly related to this. Thanks, j -- John Gateley <gateley@jriver.com>
В списке pgsql-general по дате отправления: