Postgres Pro
Downloads
Home   >   mailing lists

RE: System indexes are never unique indexes( was RE: [HACKERS] mdnblocksis an amazing time sink in huge relations) - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: System indexes are never unique indexes( was RE: [HACKERS] mdnblocksis an amazing time sink in huge relations)
Date
Msg-id 000901bf1f6a$65e40520$2801007e@cadzone.tpf.co.jp
Whole thread Raw
In response to Re: System indexes are never unique indexes( was RE: [HACKERS] mdnblocks is an amazing time sink in huge relations)  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: System indexes are never unique indexes( was RE: [HACKERS] mdnblocksis an amazing time sink in huge relations)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
> 
> > As I was afraid,2 tables of a same name could be made.
> > After a short investigating,I found that system indexes are
> > never unique indexes.
> > Why ?
> > Without duplicate index check,it's very difficult to prevent
> > objects from having same name.
> 
> They certainly should be unique.
>

All should be unique ?
I don't know system indexes well.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] mv backend/port ../../
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [PATCHES] COMMENT ON patch