| From: | "George T(dot) Gibson" <gtgibson(at)jbstamping(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Default Values |
| Date: | 2002-01-30 21:53:30 |
| Message-ID: | 001401c1a9d8$8e4410a0$8702a8c0@LITE2 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Having some trouble with default values.
My table already exists. I want to update default values so I go to the
table properties box and enter the new value for date - CURRENT_DATE.
Clicked OK and in the Log view I get:
1/30/2002 4:42:43 PM - SQL (jbsdata): ALTER TABLE "note" ALTER COLUMN
"date" DROP DEFAULT
The new default value shows up under the table properties, but when I do a
refresh the value is cleared. I'm new to this but the above sql does not
seem correct for adding a new value? Am I doing something wrong here?
Thanks for your help.
George
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-01-30 21:59:03 | Re: Consistent page fault in pgadmin2 1.2.0 |
| Previous Message | Leonardo Junquera | 2002-01-30 18:04:36 | Re: attribute 'datlastsysoid' not found |