Re: Is it bug ? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Is it bug ?
Date
Msg-id 3EEE063A.9010805@Yahoo.com
Whole thread Raw
In response to Is it bug ?  ("Ivar" <ivar@lumisoft.ee>)
List pgsql-general
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 #


pgsql-general by date:

Previous
From: "Andy Kriger"
Date:
Subject: sql standard questions
Next
From: Greg Stark
Date:
Subject: Re: full featured alter table?