Skip site navigation (1) Skip section navigation (2)

Duplicate index check in btbuild

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Duplicate index check in btbuild
Date: 2000-01-31 14:46:09
Message-ID: NDBBIJLOILGIKBGDINDFAEIKCCAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all,

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
in _bt_buildadd(). 

Comments ?

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-01-31 15:08:43
Subject: Re: Case-folding bogosity in new psql
Previous:From: Peter VazsonyiDate: 2000-01-31 14:13:55
Subject: Re: [ADMIN] Attribute 'aggtransfn1' is repeated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group