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@sss.pgh.p To: "Patrick Hatcher" <PHatcher@macys.com>
a.us> cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COPY..FROM question on 7.3
01/29/2003
04:01 PM
"Patrick Hatcher" <PHatcher@macys.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