On 10-11-22 03:24 PM, Steve Singer wrote:
> On 10-11-22 09:37 AM, Gurjeet Singh wrote:
>> On Sat, Nov 20, 2010 at 9:00 AM, Steve Singer <ssinger_pg(at)sympatico(dot)ca

> Almost fixed.
> I still get an unexpected difference.
>
> ! DETAIL: cannot create PRIMARY KEY/UNIQUE constraint with a non-unique
> index.
> CREATE UNIQUE INDEX rpi_idx2 ON rpi_test(a , b);
> -- should fail; WITH INDEX option specified more than once.
> ALTER TABLE rpi_test ADD PRIMARY KEY (a, b)
> --- 35,41 ----
> -- should fail; non-unique
> ALTER TABLE rpi_test ADD primary key(a, b) WITH (INDEX = 'rpi_idx1');
> ERROR: "rpi_idx1" is not a unique index
> ! DETAIL: Cannot create PRIMARY KEY/UNIQUE constraint using a non-unique
> index.

The attached version of the patch gets your regression tests to pass.

I'm going to mark this as ready for a committer.

In response to

• Re: Patch to add a primary key using an existing index at 2010-11-22 20:24:34 from Steve Singer

Responses

• Re: Patch to add a primary key using an existing index at 2010-11-29 01:06:42 from Itagaki Takahiro

pgsql-hackers by date

Next:	From: Maciek Sakrejda	Date: 2010-11-25 20:59:53
	Subject: Re: [JDBC] JDBC and Binary protocol error, for some statements
Previous:	From: Radosław Smogura	Date: 2010-11-25 20:46:47
	Subject: Re: [JDBC] JDBC and Binary protocol error, for some statements