Re: Problem creating index

Поиск
Список
Период
Сортировка
От Torello Querci
Тема Re: Problem creating index
Дата
Msg-id CA+igE6T06afLvGGeO4_Lv+uhYYqLZdv6N2HetcfF9KH8T5_icQ@mail.gmail.com
обсуждение исходный текст
Ответ на Problem creating index  (Torello Querci <tquerci@gmail.com>)
Ответы Re: Problem creating index  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general



2013/8/28 Dan Langille <dan.langille@gmail.com>
Same version of DB for dump & restore? If not, was the dump done via the pg_dump from the newer version. If not, please do that. 


I'm using the same version. I make this test on the same machine.
Moreover I try to remove this line using pgadmin and I get the same error (this field is part of primary key).
To remove this line I need to not use primary key but give a where condition that return only this tuple.

Again, is very strange that this data is in the database .... moreover this data came from a import procedure and this data is not present in the source import file.
Really, I think that I get some kind of data corruption


Best Regards

В списке pgsql-general по дате отправления:

Предыдущее
От: shanmugavel muthuvel
Дата:
Сообщение: virtualxid,relation lock
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Problem creating index