Re: Nullable 'Foreign Key-like' Constraint

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: rstpATlin(at)uxwav(dot)es(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Nullable 'Foreign Key-like' Constraint
Date: 2003-10-24 13:34:25
Message-ID: pbaipv03fkg7oicb83esv7gpakns2229h1@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 23 Oct 2003 16:02:03 GMT, Ron <rstpATlin(at)uxwav(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Staff, Alexander 2003-10-24 14:18:02 Index Usage Question
Previous Message Vilson farias 2003-10-24 13:28:15 Timestamp and interval precision