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@sss.pgh.pa.us> writes:
> Camm Maguire <camm@enhanced.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@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah