Re: pg_restore COPY error handling

* Bruce Momjian (pgman(at)candle(dot)pha(dot)pa(dot)us) wrote:
> Stephen Frost wrote:
> -- Start of PGP signed section.
> > * Bruce Momjian (pgman(at)candle(dot)pha(dot)pa(dot)us) wrote:
> > > Stephen Frost wrote:
> > > > Great! It'd be really nice to have this fix in 8.1.3... :)
> > >
> > > No, it will not be in 8.1.3. It is a new feature.
> >
> > I'd really appriciate it if you could review my post to pgsql-bugs,
> > Message-ID: <20060120144957(dot)GG6026(at)ns(dot)snowman(dot)net>. If this patch is
> > considered a new feature then I'd like to either revisit that decision
> > or be given some direction on what a bug-fix patch for the grows-to-3G
> > bug would look like.
>
> Oh, so when it skips the \., it reads the rest of the file and bombs
> out? I thought it just continued fine. How is that failure happening?

It doesn't actually bomb out either. On the system I was working with
what happened was that it hung after reading in the COPY data. It
looked like it got stuck somehow while trying to parse the data as an
SQL command.

Thanks,

Stephen