Colin Strickland <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl