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:
http://www.pos
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 datab
> 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' );
Ho
"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
--- 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
"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 me
Gordon A. Runkle [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?
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
> control
