Re: Problem with alter table (creating a foreing key post - Mailing list pgsql-general

Stephan Szabo wrote:

>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. ;)
>
[ Feeling *very* silly ... ] Apologies ! English not being my mother
tongue, I overlooked this (although I checked lots of time before
helling for help ...).

>
>
>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
>
Thank you !

                    Emmanuel Charpentier