Re: Problem with alter table (creating a foreing key post facto)
От | Dennis Gearon |
---|---|
Тема | Re: Problem with alter table (creating a foreing key post facto) |
Дата | |
Msg-id | SR3WURYUS54XW74UPMGCBC1UIH3WS.3e2d72cf@cal-lab обсуждение исходный текст |
Ответ на | Problem with alter table (creating a foreing key post facto) (Emmanuel Charpentier <charpent@bacbuc.dyndns.org>) |
Список | pgsql-general |
spaces not allowed in names, perhaps? 1/20/2003 11:35:38 PM, Emmanuel Charpentier <charpent@bacbuc.dyndns.org> 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 : > >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-general по дате отправления: