Thread: Default Values

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

> -----Original Message-----
> From: George T. Gibson [mailto:gtgibson@jbstamping.com]
> Sent: 30 January 2002 21:54
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Default Values
>
>
> 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.

Hi George,

Thanks for the report - I've found and fixed the bug for the next release.
In the meantime, in an SQL window, you should be able to use a query like:

ALTER TABLE "note" ALTER COLUMN "date" SET DEFAULT CURRENT_DATE

To update your columns default value.

Regards, Dave.