Re: Default Values - Mailing list pgadmin-support

From Dave Page
Subject Re: Default Values
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB10B52E9@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Default Values  ("George T. Gibson" <gtgibson@jbstamping.com>)
List pgadmin-support

> -----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.

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Consistent page fault in pgadmin2 1.2.0
Next
From: "NH-Jason"
Date:
Subject: How to change the structure of tables with pgadmin2?