Camm Maguire <camm@enhanced.com> writes:
> 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.
I'm a bit startled that COPY to a view works at all ;-). But it does
look like copy honors triggers, so in principle the above ought to work.
I'll need to see the complete details of the trigger and all the
referenced table declarations --- probably don't need the data, though,
unless the trigger needs to have nonempty tables to start with.
regards, tom lane