how to rename an unnamed uniqueness constraint?
От | Oliver Kullmann |
---|---|
Тема | how to rename an unnamed uniqueness constraint? |
Дата | |
Msg-id | 20050816164353.GA7702@cs-wsok.swansea.ac.uk обсуждение исходный текст |
Ответы |
Re: how to rename an unnamed uniqueness constraint?
|
Список | pgsql-novice |
Hello, I have a table created with CREATE TABLE Current_academic_year ( year_id INT REFERENCES Academic_years, CONSTRAINT year_id CHECK(year_id IS NOT NULL), active BOOL NOT NULL, UNIQUE(year_id), UNIQUE(active) ) ; Now I need to drop the constraint "UNIQUE(active)". I tried variations of ALTER TABLE current_academic_year DROP CONSTRAINT "???" but I didn't succeed. I'm using version 7.4.8. Thanks in any case for your efforts! Oliver P.S. The "documentation" regarding the e-mail lists is really the most arcane I've ever seen. I have no idea how I'm supposed to post to a list, and/or to receive mails. Of course I tried http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org and the help pages etc.: I always get "unsuccessful" back, and the e-mails I get from "majordomo" just tell me that I was unsuccessful (with registration). And then there is "Sign in", "Sign out" ??? Just one paragraph about the idea how the average *novice* should post a question and read the answer would be quite useful.
В списке pgsql-novice по дате отправления: