On Thu, 23 Oct 2003 16:02:03 GMT, Ron <[EMAIL PROTECTED]>
wrote:
> ALTER TABLE project ADD CONSTRAINT company_is_ta companyID
> REFERENCES company(companyID);
> (plus variations on the above, resulting in errors, all similar to:)
> ERROR: parser: parse error at or near "companyID" at character 53
ALTER TABLE project ADD CONSTRAINT company_is_ta
FOREIGN KEY (companyID) REFERENCES company(companyID);
^^^^^^^^^^^^^ ^
Servus
Manfred
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
