Re: Constraints not check indexes existence on creation.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Constraints not check indexes existence on creation.
Date: 2003-02-13 05:27:54
Message-ID: 10729.1045114074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)ua> writes:
> Why alter table commands not check index existence?

What do you want them to do exactly? Error out if there's an equivalent
index in place already? Absorb the index as the implementation of the
constraint? I don't really like either of those ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pablo Capeluto 2003-02-13 10:06:11 PGSQL no IP-port assigned
Previous Message Tom Lane 2003-02-12 23:27:01 Re: Bug #866 related problem (ATTN Tom Lane)