Re: Default Values

[Dave Page]

> -----Original Message-----
> From: George T. Gibson [mailto:[EMAIL PROTECTED]] 
> Sent: 30 January 2002 21:54
> To: [EMAIL PROTECTED]
> 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.