I need help
Has somebody experienced difficulties using COPY
command on large files.
I have a large (250MB) file and each time I insert
records I've got one or more (< 30 of cca 1079000)
corrupted
records. The number of corrupted records is not
constant (i.e. 1, 30, 7, 23 etc..)
p.s. the
"Nikola Ivacic" <[EMAIL PROTECTED]> writes:
> Has somebody experienced difficulties using COPY command on large files.
> I have a large (250MB) file and each time I insert records I've got one or =
> more (< 30 of cca 1079000) corrupted
> records. The number of corrupted records is not constant (i.
It must be internal error:
two reasons:
1.) the original file is OK (I checked with grep + there is no network
envolved)
2.) Error has strange patern: it substitutes 0x31 with 0x21 (1 with !) also
0x34 with 0x24 (4 with $)
and 0x39 with 0x29 (9 with ) )
so I guess you are right.
can you suggest s
