timestamp 'default' question

From: Charles Hauser <chauser(at)duke(dot)edu>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: timestamp 'default' question
Date: 2003-03-13 19:28:15
Message-ID: 1047583695.6587.28.camel@pandorina.biology.duke.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

I have a TABLE entry for time:

timeaccessioned | timestamp without time zone | not null default
('now'::text)::timestamp(6) with time zone

w/ default set to 'now', I thought postgres would fill in time - not so?

When I attempt to load feature table w/out time entered ->

psql:feature.stdin:1: ERROR: copy: line 1, Missing data for column
"timeaccessioned"

COPY feature (feature_id, dbxref_id, organism_id, name, uniquename,
residues, seqlen, md5checksum, type_id, timeaccessioned,
timelastmodified) FROM stdin;
1 \N 133 scaffold_1 chlre01.1 AAATCCAAGC
376197 53adae6396a767c7e88910c73b9d0b6b 3
\.

Can I get postgres to load current time, or do I need to generate it in
the script creating the SQL?

Charles

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dousak May (Phoebus Apollonus) 2003-03-13 19:30:10 Re: Function in selection?
Previous Message Eric Audet 2003-03-13 19:19:39 Droping a database even if someone is connected