Re: [GENERAL] Syntax of: alter table ... add constraint ...

[Thomas Kellerer]

Alexander Farber, 08.11.2010 15:50:
 
And then I realized that I actually want
     medals smallint default 0 check (medals>= 0)

So I've dropped the old constraint with

     alter table pref_users drop constraint "pref_users_medals_check";

but how can I add the new contraint please? I'm trying:

alter table pref_users add constraint pref_users_medals_check (medals>= 0);
ERROR:  syntax error at or near "("
LINE 1: ...pref_users add constraint pref_users_medals_check (medals>=...
                                                              ^
and many combinations of quotes and "check" inbetween,
but can't find the correct syntax

That should work:

alter table pref_users add constraint pref_users_medals_check check check (medals 
>= 0);

Thomas


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general