[GENERAL] re: 7.1.2 and foreign key unique constraint.

2001-08-02 Thread patrick keshishian
Greetings, I ran accross this problem upon upgrading our database from 7.0.3 to 7.1.2: ERROR: UNIQUE constraint matching given keys for referenced table "some_table" not found Looking through the mailing lists i came across a couple of discussions regarding this very same error: ht

Re: [GENERAL] re: 7.1.2 and foreign key unique constraint.

2001-08-02 Thread Stephan Szabo
> I ran accross this problem upon upgrading our database from 7.0.3 > to 7.1.2: > >ERROR: UNIQUE constraint matching given keys for referenced >table "some_table" not found Yeah, we fixed this to follow spec (sql actually requires that the references be to a unique or primary key const