Re: COPY..FROM question on 7.3

Unfortunately, I thought that was what you were going to say. Time to pull
out the PERL scripts
Thanks

Patrick Hatcher
Macys.Com

Tom Lane
<tgl(at)sss(dot)pgh(dot)p To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
a.us> cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] COPY..FROM question on 7.3
01/29/2003
04:01 PM

"Patrick Hatcher" <PHatcher(at)macys(dot)com> writes:
> Trying to import a 4 column tab delimited file into Pg 7.3. As it
stands,
> the last line contains only the first two columns. I would expect that
the
> import would only update the first two column like it did in Pg 7.2.x.
> However, I get an error message Missing data from column "X".
> Is there something I can do to avoid the message?

Yes, fix the data file ;-). This was deliberately tightened in 7.3 to
detect the sorts of obscure mistakes that the old behavior allowed to
slip by ...

regards, tom lane