| From: | Philipp Ottlinger <ottlinger(at)computer-systeme(dot)de> |
|---|---|
| To: | ryanne cruz <ryanne(dot)cruz(at)up(dot)edu(dot)ph> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: not null |
| Date: | 2003-01-25 11:51:48 |
| Message-ID: | 3E327A54.8030800@computer-systeme.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
ryanne cruz wrote:
>
> hi list.
>
> i have a column that has a "not null" as its modifier. is there a way that i
> can remove that? or better yet to make it a "serial not null"?
>
It depends on your entitiy-relationship schema - usually it makes sense
to define things as "not null" and it shouldn't be considered to be
taken away just by chance !!!
Usually you can alter the TABLE to remove such constraints ...
SERIAL - if I'm not too mistaken - is automatically maintained by
postgres as an implicit sequence whose values are generated by calling
sequence.nextval autonomously everytime you "need" a value!
Yours,
Phil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ryanne cruz | 2003-01-25 11:52:40 | not null |
| Previous Message | Borsos József | 2003-01-24 17:57:22 | what do I wrong??? |