Re: Is it bug ?

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 #