BUG #2627: syntax error in COPY using pgAdmin III Query
От | Guillermo Reisch |
---|---|
Тема | BUG #2627: syntax error in COPY using pgAdmin III Query |
Дата | |
Msg-id | 200609131802.k8DI2brT062916@wwwmaster.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2627 Logged by: Guillermo Reisch Email address: guillere@adinet.com.uy PostgreSQL version: 8.1.4-1 Operating system: Windows XP SP2 Description: syntax error in COPY using pgAdmin III Query Details: Problem to fill a table using COPY. I have a SQL file (table1.sql) with the information of tabla1 to put using commando Copy, if run script file with "pgAdmin III" using the "tools=>Query tool" it generate an error. However if I run script from âpsql to 'posgres'â using the option "\i table1.sql" , it works perfectly. table1 info: CREATE TABLE table1 ( col1 int4, col2 int4, col3 int4 ) WITHOUT OIDS; ALTER TABLE table1 OWNER TO postgres; File table1.sql: ---------------------------------------------- COPY table1 (col1, col2, col3) FROM stdin; 5 10 15 20 30 40 7 8 0 \. ---------------------------------------------- Output mensaje from pgAdmin III Query: ERROR: syntax error at or near "5" at character 61 steps to follow to produce the error: 1 Create table1(int4, int4, int4) 2 open tools=>Query tool 3 load "table1.sql" 4 run script
В списке pgsql-bugs по дате отправления: