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

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RE: System indexes are never unique indexes( was RE: [HACKERS] mdnblocksis an amazing time sink in huge relations)
Date: 1999-10-26 04:27:22
Message-ID: 000901bf1f6a$65e40520$2801007e@cadzone.tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> > 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(at)tpf(dot)co(dot)jp

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-26 04:34:45 Re: [HACKERS] Re: [PATCHES] COMMENT ON patch
Previous Message Bruce Momjian 1999-10-26 04:16:19 Re: [HACKERS] mv backend/port ../../