Re: ALTER TABLE ... SET DEFAULT

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(at)mccons(dot)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"