Re: [GENERAL] Copy fails
Abraham, Danny wrote: > I am loading a huge file using C, STDIN Using C? Have you written a C program using libpq to load some data, which it reads from its stdin? Or do you mean COPY FROM STDIN ? Something else? Perhaps if you provided a clearer and more complete explanation of your problem you might get a more useful answer. > The program fails immediately on "canceling statement due to statement > timeout" Do you have a statement timeout set in postgresql.conf ? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Copy fails
I am loading a huge file using C, STDIN The program fails immediately on "canceling statement due to statement timeout" Any idea? Thanks Danny -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] COPY fails to read source file
On Tue, May 16, 2000 at 01:57:19PM -0400, Bill Barnes wrote: > Hello all: > > Using 6.5.3, SuSE 6.4, logged in as 'billb'. > > Here are 2 instances of the COPY command; > > - > copy custprofile from '/home/billb/custpr.txt' using delimiters ';'; > The result is: > ERROR: COPY command, running in backend with with effective uid 26, could > not open '/home/billb/custpr.txt' for reading. Errno = Permission denied > (13). > The file looks like > -rw-r--r-- 1 billb users 58902 May 16 11:45 /home/billb/custpr.txt What do permissions on home and billb look like? I'm guessing your missing an 'x' in there (probably on billb). > > copy custprofile from '/mnt/DOS_C/sybase/custpr.txt' using delimiters ';'; > The result is: > COPY > The file looks like > -rwxr-xr-x 1 rootroot 58902 May 16 11.56 /mnt/DOS_C/sybase/custpr.txt > > --- > > The second instance gave me the results I wanted, but why did the first > instance fail? If anything, I would have expected permission denied on the > root owner. I have had the same results on other ocassions. > > What am I missing? That the two examples have different paths through the filesystem tree. Ross -- Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
[GENERAL] COPY fails to read source file
Hello all: Using 6.5.3, SuSE 6.4, logged in as 'billb'. Here are 2 instances of the COPY command; - copy custprofile from '/home/billb/custpr.txt' using delimiters ';'; The result is: ERROR: COPY command, running in backend with with effective uid 26, could not open '/home/billb/custpr.txt' for reading. Errno = Permission denied (13). The file looks like -rw-r--r-- 1 billb users 58902 May 16 11:45 /home/billb/custpr.txt copy custprofile from '/mnt/DOS_C/sybase/custpr.txt' using delimiters ';'; The result is: COPY The file looks like -rwxr-xr-x 1 rootroot 58902 May 16 11.56 /mnt/DOS_C/sybase/custpr.txt --- The second instance gave me the results I wanted, but why did the first instance fail? If anything, I would have expected permission denied on the root owner. I have had the same results on other ocassions. What am I missing? TIA Bill Barnes This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com