Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

3226:16652 --

Mac OS X
omfgppc
2009-01-07
2013-03-08
  • omfgppc
    omfgppc
    2009-01-07

    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 \"company\"

    ********** Error **********

    ERROR: there is no unique constraint matching given keys for referenced table \"company\"
    SQL state: 42830[/code:1:477265a41b] -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=3226