| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: changing field length |
| Date: | 2003-08-20 14:39:25 |
| Message-ID: | 3F43881D.2020908@virginia.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
ExecUpdate: Fail to add null value in not null attribute study_name
Is there any way around this error. Col1 is a not null field but col2 is
not obviously since it is currently empty!
Thanks for the help.
Jodi
Bruno Wolff III wrote:
>On Wed, Aug 20, 2003 at 10:16:38 -0400,
> Jodi Kanter <jkanter(at)virginia(dot)edu> wrote:
>
>>how do I copy from one field to another?
>>
>
>update tablename set newcol = oldcol;
>
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jodi Kanter | 2003-08-20 14:40:27 | Re: changing field length |
| Previous Message | Dani Oderbolz | 2003-08-20 14:35:00 | Sobig.f in the list |