Re: timestamp 'default' question

Charles Hauser <chauser(at)duke(dot)edu> writes:
> When I attempt to load feature table w/out time entered ->
> psql:feature.stdin:1: ERROR: copy: line 1, Missing data for column
> "timeaccessioned"

Well, yes, because your COPY command is claiming that all eleven columns
will be supplied in the input:

> 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
> \.

I think what you probably intend is

COPY feature (feature_id, dbxref_id, organism_id, name, uniquename,
residues, seqlen, md5checksum, type_id) FROM stdin;

which tells COPY to read those columns from the input and insert
defaults for the remaining columns.

regards, tom lane