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(at)Yahoo(dot)com #