A bug with unique indicies
От | Aditya Damle |
---|---|
Тема | A bug with unique indicies |
Дата | |
Msg-id | 3A666114.D9F4B2C5@2028.com обсуждение исходный текст |
Ответы |
Re: A bug with unique indicies
|
Список | pgsql-hackers |
Hello. Hopefully, this is the right mailing list to send this type of question too. System: I am running the newest 7.03 build on a dual 866 Pentium III with a 128M raid card. I have found an error that is quite odd. I have a table that is supposed to keep a map between urls and ids. Each url in the table should be unique. Thus I have Create table "urlmap" ( "url" text not NULL, "id" int4 not NULL, PRIMARY KEY ("url"), UNIQUE ("id","url") ); After inserting a number of urls (via spidering) i did the following. I vacuumed the db : vacuum verbose analyze. First: select * from urlmap where url='blah blah'; Here I got back only one row. Good. Then i went ahead reindexed the table: I recieved the error: Cannot create unique index. Table contains non-unique values. Same problem occurs if I drop the indicies and try to recreate them. I then : select * from urlmap u1,urlmap u2 where u1.url=u2.url and u1.oid!=u2.oid I then got back two rows where the url was indeed the same and the associated id different. Why, would this ever occur? -Aditya
В списке pgsql-hackers по дате отправления: