[ Charset ISO-8859-1 unsupported, converting... ]
> Um, excuse me. Any changes to the format of pg_shadow will break
> pg_dumpall, therefore this needs to be hold back until next release.
>
Woo, hoo. We have triggers and constraints on COPY. We could do the
default values that way. Seems DEFAULT is not activated in COPY. I
knew there was some limitation in COPY.
test=> create table test(x int, y int default 5);CREATEtest=> copy test from '/tmp/x';COPYtest=> select * from test; x
|y ---+--- 1 | (1 row)
Can someone suggest a clean solution for COPY? Seems we have triggers
and constraints.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026