Re: Is it bug ?

> We maybe should relocate auto-created indexes for UNIQUE and PKEY
> definitions into some sort of special schema and give them funny names?
MS SQL adds funny names as columnName_236321_215251_156, seems that adds
some random at end to avoid similar errors.


"Jan Wieck" <JanWieck@Yahoo.com> wrote in message
news:3EEE063A.9010805@Yahoo.com...
> Ivar wrote:
> > Hi,
> >
> > Is it bug ?
> > Try to create these tables with following order
> >
> > CREATE TABLE m_tvh (
> >  web_teid varchar(40) UNIQUE
> > );
> >
> > CREATE TABLE m_tvh_web (
> >  teid varchar(40) UNIQUE
> > );
> >
> > Both wany make index with name 'm_tvh_web_teid_key'.
> >
> > Postgre version = 7.3.1.
>
> I would say so. I don't think the standard forbids the above, and if
> that is right, it clearly is a bug.
>
> We maybe should relocate auto-created indexes for UNIQUE and PKEY
> definitions into some sort of special schema and give them funny names?
>
>
> Jan
>
> --
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me.                                  #
> #================================================== JanWieck@Yahoo.com #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>