| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: alter table and constraints |
| Date: | 2000-08-25 17:28:03 |
| Message-ID: | Pine.BSF.4.10.10008251026100.36855-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 25 Aug 2000, Martin A. Marques wrote:
> I don't know if this is posible, but I'm trying to add and delete
> constrains from a table. Is this posible and why am I having so much
> problems?
In 7.0 you can add foreign key constraints with ALTER TABLE, but you
cannot add other constraints or remove constraints with it. Some
constraints can be added or removed in other ways, what are you trying to
do precisely?
[In current sources you should also be able to add check constraints.]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2000-08-25 17:46:33 | Re: ECPG and SQL function |
| Previous Message | Jackson Ching | 2000-08-25 16:37:57 | Getting the result of a query using COUNT(*) |