Re: Nullable 'Foreign Key-like' Constraint - Mailing list pgsql-general

On Thu, 23 Oct 2003 16:02:03 GMT, Ron <rstpATlin@uxwav.esDOTcom>
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