Re: Is it bug ?

May be its wiser to add additional(may be more than 1) _ between table and
column.

This solves problem.

(For current problem it works, see if I'm missing somethig)


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'.

new results will be:
1) m_tvh__web_teid
2) m_tvh_web__teid



"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:170.1055956685@sss.pgh.pa.us...
> "Ivar" <ivar@lumisoft.ee> writes:
> > "Jan Wieck" <JanWieck@Yahoo.com> wrote
> >> 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.
>
> I think it's good that the index name is predictable.  I think we should
> stick to the existing behavior as much as we can.
>
> It would probably make sense to check if the generated name is actually
> unused, and to stick some digits on the end if not.  For example, try
> tab_col_key
> tab_col_key1
> tab_col_key2
> etc. until we find an unused name.  Of course this is still subject to
> race conditions, but I think in practice it will solve the problem.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>