Re: copy from stdin limits

Greetings, and thank you for your reply.

OK, I have 4 tables, and a view on a merge of the 4. I have a trigger
on insert into table 3, and a trigger on insert into the view, which
basically just takes the input data, does a few selects on the tables,
and inserts the appropriate portions of the data into each table as
necessary.

When I copy up to ~ 1000 lines of a file into this view, everything
goes fine. More than that, and after a while, cpu activity stops,
disk activity stops, and the job hangs indefinitely. Control-C gives
the later message "You have to get out of copy state yourself". I can
provide the schema if needed.

Thanks for your help!

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Camm Maguire <camm(at)enhanced(dot)com> writes:
> > Greetings! 'copy from stdin' on 7.0.2 appears to simply hang if more
> > than ~ 1000 records follow in one shot. I couldn't see this behavior
> > documented anywhere. Is this a bug?
>
> I've never heard of any such behavior ... and you can be sure that we'd
> have heard about this, since any moderately large pg_dump file would
> trigger such a bug. You must have something else going on. Details
> please?
>
> regards, tom lane
>
>

--
Camm Maguire camm(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah