Re: Problem with alter table (creating a foreing key post - Mailing list 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