| From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Adding a column with constraint |
| Date: | 2011-02-24 18:30:32 |
| Message-ID: | AANLkTi=FcLm-EgChqm6aPT_q_ns04PF9vFqsUtrsLNNq@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a paranoic question.
In PostgreSQL 8.4.7 I had a table to store started, completed and
interrupted games :
# \d pref_match
Table "public.pref_match"
Column | Type | Modifiers
-----------+-----------------------+-----------------------------------------
id | character varying(32) |
started | integer | default 0
completed | integer | default 0
quit | integer | default 0
yw | character(7) | default to_char(now(), 'IYYY-IW'::text)
Check constraints:
"pref_match_completed_check" CHECK (completed >= 0)
"pref_match_quit_check" CHECK (quit >= 0)
"pref_match_started_check" CHECK (started >= 0)
Foreign-key constraints:
"pref_match_id_fkey" FOREIGN KEY (id) REFERENCES pref_users(id)
And have tried to add a column "win" with a check (to document the won games):
# alter table pref_match add column win integer default 0 check
(completed >= win and win >= 0);
Now I have:
# \d pref_match
Table "public.pref_match"
Column | Type | Modifiers
-----------+-----------------------+-----------------------------------------
id | character varying(32) |
started | integer | default 0
completed | integer | default 0
quit | integer | default 0
yw | character(7) | default to_char(now(), 'IYYY-IW'::text)
win | integer | default 0
Check constraints:
"pref_match_check" CHECK (completed >= win AND win >= 0)
"pref_match_completed_check" CHECK (completed >= 0)
"pref_match_quit_check" CHECK (quit >= 0)
"pref_match_started_check" CHECK (started >= 0)
Foreign-key constraints:
"pref_match_id_fkey" FOREIGN KEY (id) REFERENCES pref_users(id)
Shouldn't the line
"pref_match_check" CHECK (completed >= win AND win >= 0)
above actually be:
"pref_match_win_check" CHECK (completed >= win AND win >= 0)
? Does it indicate something went wrong or is it just cosmetic issue?
Thank you
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2011-02-24 18:39:48 | Re: regexp problem |
| Previous Message | Gauthier, Dave | 2011-02-24 18:25:43 | regexp problem |