Re: [GENERAL]COPY still running

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(at)iris-tech(dot)fr
______________________________