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
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,
--- 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
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 l
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
