Dirk Lutzebaeck a écrit :
> Arnaud FLORENT writes:
> > Hello i start yesterday afternoon a COPY command into a table.
> > the file is 15 Mb
> > i've set triggers before and after insert on the table
> > the before trigger just perform data check.
> > the after trigger update a 10 000 rows linked table.
> >
> > the COPY command runs all the night ad has not yet finished...........
> >
> > what is the problem????
> >
>
> You probably have indexes defined on this table. You should drop all
> the indexes before the copy and create them after the copy if the
> number of rows in the copy commands exceeds the number of the current
> rows in the table.
>
> I have dropped the indexes while copy'ing which seems to be no
> problem. Just create them after the copy is finished. Ymmv...
>
sure, but i think unique constraints will be lost without index on my
table......
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent@iris-tech.fr
______________________________