Re: Problem with alter table (creating a foreing key post

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with alter table (creating a foreing key post
Date: 2003-01-21 07:38:27
Message-ID: 20030120233732.B75599-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 21 Jan 2003, Emmanuel Charpentier wrote:

> A curious problem with 7.3.1 : I wanted to add a foreing key constraint to
> a table already created and populated. No way, according to Postgres :

It helps if you spell foreign correctly. ;)

> essai=# alter table tableb add constraint lien_a_a foreing key (refa)
> references tablea (keya);
> ERROR: parser: parse error at or near "foreing" at character 44
> essai=# alter table tableb add foreing key (refa) references tablea (keya);
> ERROR: parser: parse error at or near "(" at character 36

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier 2003-01-21 07:44:20 Re: Problem with alter table (creating a foreing key post
Previous Message Emmanuel Charpentier 2003-01-21 07:35:38 Problem with alter table (creating a foreing key post facto)