Currently btbuild() rejects duplicate index in comparetup_index().
But there are some cases that index tuples for already deleted
heap tuples should be made. comparetup_index() doesn't work
well in such cases because comparetup_index() couldn't ignore
deleted tuples. In addition I could find no other place to check
index uniqueness in tuplesort.c .
Seems we have to give up the uniqueness check in comparetup_
index() and have to check it in _bt_buildadd().
We would be able to take the visibility of heap tuples into acount
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-01-31 15:08:43|
|Subject: Re: Case-folding bogosity in new psql |
|Previous:||From: Peter Vazsonyi||Date: 2000-01-31 14:13:55|
|Subject: Re: [ADMIN] Attribute 'aggtransfn1' is repeated|