Default Values

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

Browse pgadmin-support by date

  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