willalvord wrote: I did that -- a couple of times.
The below line from 301to310alpha/alterAccountSegments.sql seems to be prompting the error:
ALTER TABLE accnt ADD FOREIGN KEY (accnt_company) REFERENCES company(company_number) ON UPDATE CASCADE;
This is the output of that statement from pgAdmin:
[code:1:477265a41b]ERROR: there is no unique constraint matching given keys for referenced table \&quot;company\&quot;
********** Error **********
ERROR: there is no unique constraint matching given keys for referenced table \&quot;company\&quot;
SQL state: 42830[/code:1:477265a41b] -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=3226
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.