Problem with alter table (creating a foreing key post facto)

From: Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with alter table (creating a foreing key post facto)
Date: 2003-01-21 07:35:38
Message-ID: b0it8a$qbe$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 :

Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

essai=# \d tablea
Table "public.tablea"
Column | Type | Modifiers
--------+---------+----------------------------------------------------------
keya | integer | not null default nextval('public.tablea_keya_seq'::text)
vala | text |
Indexes: tablea_pkey primary key btree (keya)

essai=# \d tableb
Table "public.tableb"
Column | Type | Modifiers
--------+---------+----------------------------------------------------------
keyb | integer | not null default nextval('public.tableb_keyb_seq'::text)
refa | integer | not null
valb | text |
Indexes: tableb_pkey primary key btree (keyb)

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

WTF ????

Any ideas ?

Sincerely,

Emmanuel Charpentier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-01-21 07:38:27 Re: Problem with alter table (creating a foreing key post
Previous Message CSN 2003-01-21 07:17:54 grant to all tables