ALTER TABLE ... SET DEFAULT

From: Brian McCane <bmccane(at)mccons(dot)net>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: ALTER TABLE ... SET DEFAULT
Date: 2002-04-12 07:02:29
Message-ID: 20020412015602.S18686-100000@fw.mccons.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a field called 'updated' of type 'integer' in a table. I have
created a function called 'since_epoch' which is declared with iscacheable
and returns the value of 'extract(epoch from now())'. I want to make
'updated' have a default of 'since_epoch()'. I cannot get it to work with
the following command:

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()"

I tried using 'since_epoch()::integer', but that failed as well.
Is it possible to make the default value of an integer field use a
function similar to how we use 'now()' for date and timestamp fields?

- brian

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

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2002-04-12 07:21:07 Re: ALTER TABLE ... SET DEFAULT
Previous Message Tom Lane 2002-04-11 22:02:23 Re: More question about plans & explain (long)