Colin Strickland <cms(at)sift(dot)co(dot)uk> writes:
>   PRIMARY KEY
> (dir_suppliers_var_prodtype_id,dir_suppliers_var_prodtype_id)
 
> My question is, should this not raise a parser error ?

Yes, it should.  SQL92 saith

         4) Each <column name> in the <unique column list> shall identify
            a column of T, and the same column shall not be identified more
            than once.

Looks like we neglect to make that check during initial processing of
the PRIMARY KEY clause.

			regards, tom lane

In response to

• CREATE TABLE .. PRIMARY KEY quirk at 2001-07-04 13:28:46 from Colin Strickland

pgsql-hackers by date

Next:	From: Hiroshi Inoue	Date: 2001-07-04 23:43:24
	Subject: Re: Re: Buffer access rules, and a probable bug
Previous:	From: Tom Lane	Date: 2001-07-04 17:09:08
	Subject: Re: Re: Buffer access rules, and a probable bug