Hi Folks,
Well I think i had 'now' in there in someplaces and that got parsed.
I've fixed it in all databases on my system now, so doing forward I'm
safe.
However there is a 2 week period in which the dates for some items are
not what they should be. Of course they should be "now()" whenever now
was at the time, but they are all
2005-09-21 21:09:59.180154-04
I was wondering if there was a way I could use the WAL logs to find
what date certain oid's were inserted. Then query my table where date
= 2005-09-21 21:09:59.180154-04, corelate the time in teh WAL log and
update my table..
But I've no idea how to iteract with the wal log.
Thanks again folks.
> Could you have done something like:
>
>
> CREATE TABLE ts_def_test2(a int4, b timestamp with time zone default 'now');
>
> Which gives:
>
> CREATE TABLE ts_def_test2 (
> a integer,
> b timestamp with time zone DEFAULT '2005-10-05
> 00:08:05.381034+01'::timestamp with time zone
> );
>
> The difference being that 'now' is a literal timestamp (with timezone)
> that gets evaluated in your CREATE TABLE statement.