Skip site navigation (1) Skip section navigation (2)

Re: ALTER TABLE ... SET DEFAULT

From: Brian McCane <bmccane(at)mccons(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ALTER TABLE ... SET DEFAULT
Date: 2002-04-13 00:19:01
Message-ID: 20020412191819.B59745-100000@fw.mccons.net (view raw or flat)
Thread:
Lists: 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(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"


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2002-04-13 00:27:56
Subject: Re: A *short* planner question
Previous:From: Nick FankhauserDate: 2002-04-12 23:31:48
Subject: Re: A *short* planner question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group