Re: ALTER TABLE ... SET DEFAULT - Mailing list pgsql-admin

From Brian McCane
Subject Re: ALTER TABLE ... SET DEFAULT
Date
Msg-id 20020412191819.B59745-100000@fw.mccons.net
Whole thread Raw
In response to Re: ALTER TABLE ... SET DEFAULT  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ALTER TABLE ... SET DEFAULT
List pgsql-admin
Been there, done that :).  It put the current epoch value in as the
default value for updated.

- brian

On Fri, 12 Apr 2002, Tom Lane wrote:

>
> Brian McCane <bmccane@mccons.net> writes:
> > alter table foo alter column updated set default 'since_epoch()' ;
> > this gets the error:
> > ERROR:  pg_atoi: error in "since_epoch()": can't parse "since_epoch()"
>
> Try it without the quotes.
>
>             regards, tom lane
>

Wm. Brian McCane                    | Life is full of doors that won't open
Search http://recall.maxbaud.net/   | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"


pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: A *short* planner question
Next
From: Tom Lane
Date:
Subject: Re: A *short* planner question