Is that the *first* error message you got?
Yes it is.
In fact I made a mistake in the first email, so instead:
INSERT INTO A ( Col1, Col2 )
VALUES (2, '-- any text' );
please change with:
INSERT INTO A ( Col1, Col2 )
VALUES (1, '-- any text' );
However I
Sabin Coanda wrote:
Hi,
I have PostgreSQL 8.3.5, compiled by Visual C++ build 1400 on Windows OS.
I try to use the COPY command to optimize the backup/restore performance,
but I found a problem. I reproduce it below.
I can't reproduce it here on 8.3 on linux.
I backup the database
Sorry, my fault that I run the script in the query window of pgAdmin, not in
the system console. I check it again in the system console and it works
well.
Thanks,
Sabin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi,
I have PostgreSQL 8.3.5, compiled by Visual C++ build 1400 on Windows OS.
I try to use the COPY command to optimize the backup/restore performance,
but I found a problem. I reproduce it below.
I create a database with a simple table:
CREATE TABLE A
(
Col1 integer NOT NULL,
Col2
Sabin Coanda [EMAIL PROTECTED] writes:
I backup the database plain with the command:
pg_dump.exe -U postgres -F p -v -f backup_plain.sql DemoDB
I create a new database, and I run the script. But it rise me the error:
ERROR: syntax error at or near 1
LINE 49: 1 -- any text
I look for
--- Ron [EMAIL PROTECTED] wrote:
I am creating a new database on a brand new server
(P4, 1GB RAM,
postgres 7.3.3, debian 3.0) and trying to populate
one of the tables
with the COPY command. I split a large file with 20
million records into
20 files, but when I run COPY I usually get the
"Creager, Robert S" [EMAIL PROTECTED] writes:
I'm working with 2.5 million records btw. I've narrowed the situation to
occur when copying to any one of the 5 referring tables (COPY u FROM stdin).
The backend process which handles the db connection decides that it needs a
whole lot of memory,
In article [EMAIL PROTECTED],
"Creager, Robert S" [EMAIL PROTECTED] wrote:
I think this is a question regarding the backend, but...
[snip]
(COPY u FROM stdin). The backend process which handles the db connection
decides that it needs a whole lot of memory, although in a nice
controlled
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:18 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] COPY problem
I can't answer the backend question, but how about running
'split' on the big file, then COPYing these smaller files?
Gordon.
---(end
I think this is a question regarding the backend, but...
I'm in the process of changing 1 large table (column wise) into 6 smaller
tables, and ran into a situation. I'm using Postgresql 7.1beta5, Pg as
included, Perl 5.6, Solaris 2.6 on an Ultra 5.
The new setup is 6 tables, the 'main' table
Gustavo Berns wrote:
I have a problem with the COPY maybe someone can help?
The superuser is " webadmin" uid 504, then I did create a second user
"aaadir" with superuser rights.
When I try to insert data from a file, it give me the following message:
ERROR: COPY command, running in backend with
11 matches
Mail list logo