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@iris-tech.fr
______________________________