On Fri, 24 Oct 2003 18:19:05 GMT, Ron <[EMAIL PROTECTED]>
wrote:
>When I try the following with my current database I
>get an error:
> giibdb=# ALTER TABLE project ADD CONSTRAINT company_is_ta FOREIGN
> KEY (companyID) REFERENCES tblCompanies(companyID);
> NOTICE: ALTER TABL
ctober 23, 2003 9:02 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Nullable 'Foreign Key-like' Constraint
I posted this to 'questions' yesterday instead of 'general' by mistake.
Sorry if anyone received duplicates.
Manda
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 c
PROTECTED]
Subject: [GENERAL] Nullable 'Foreign Key-like' Constraint
I posted this to 'questions' yesterday instead of 'general' by mistake.
Sorry if anyone received duplicates.
Mandatories: Ver 7.3.4, Redhat Lin
:Fax
206.335-8386:Cell
-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 9:02 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Nullable 'Foreign Key-like' Constraint
I posted this to 'questions' yesterday
I posted this to 'questions' yesterday instead of 'general' by mistake.
Sorry if anyone received duplicates.
Mandatories: Ver 7.3.4, Redhat Linux 8.0, P4, 2GB RAM
I want to add a 'nullable' foreign key to a column in a table. I have
tables "c
