Hi Kevin,
On Tue, 3 Feb 2004, Kevin Brown wrote:
> Slavisa Garic wrote:
> > Using pg module in python I am trying to run the COPY command to populate
> > the large table. I am using this to replace the INSERT which takes about
> > few hours to add 7 entries where copy takes minute and a half.
Kevin Brown <[EMAIL PROTECTED]> writes:
> Slavisa Garic wrote:
>> Using pg module in python I am trying to run the COPY command to populate
>> the large table. I am using this to replace the INSERT which takes about
>> few hours to add 7 entries where copy takes minute and a half.
> That diff
Slavisa Garic wrote:
> Using pg module in python I am trying to run the COPY command to populate
> the large table. I am using this to replace the INSERT which takes about
> few hours to add 7 entries where copy takes minute and a half.
That difference in speed seems quite large. Too large.
Slavisa Garic <[EMAIL PROTECTED]> writes:
> ... I get the following error on Linux
> machine even if permissions on the data file are 777:
> _pg.error: ERROR: COPY command, running in backend with effective uid
> 26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata'
> for
On Tue, 3 Feb 2004, Slavisa Garic wrote:
> My understanding is that COPY workes FROM 'filename' or STDIN where the
> last characters are '.\\n'. I tried using the copy from 'filename' and as
> I said NetBSD is not complaining where I get the following error on Linux
> machine even if permissions
