BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “iso-8859-1 error”
От | PG Bug reporting form |
---|---|
Тема | BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “iso-8859-1 error” |
Дата | |
Msg-id | 16127-cd8faadee42e85d5@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “Unknown error”
Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “iso-8859-1 error” |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16127 Logged by: yanliang lei Email address: leiyanliang@highgo.com PostgreSQL version: 12.1 Operating system: Windows 2008 R2 Description: D:\>dir 驱动器 D 中的卷是 新加卷 D:\Program Files\PostgreSQL\12>cd bin D:\Program Files\PostgreSQL\12\bin>psql -d postgres -U posgres 用户 posgres 的口令: psql: 错误: 无法连接到服务器:FATAL: password authentication failed for user "p osgres" D:\Program Files\PostgreSQL\12\bin>psql -d postgres -U postgres 用户 postgres 的口令: psql (12.1) 输入 "help" 来获取帮助信息. postgres=# select version(); version ------------------------------------------------------------ PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit (1 行记录) postgres=# CREATE TABLE github_events postgres-# ( postgres(# event_id bigint, postgres(# event_type text, postgres(# event_public boolean, postgres(# repo_id bigint, postgres(# payload jsonb, postgres(# repo jsonb, postgres(# user_id bigint, postgres(# org jsonb, postgres(# created_at timestamp postgres(# ); CREATE TABLE postgres=# \timing 启用计时功能. postgres=# set client_encoding='UTF8'; SET 时间:1.185 ms postgres=# set lc_messages=en_us; SET 时间:23.467 ms postgres=# copy github_events from 'd:\large_events.csv' csv; ERROR: could not stat file "d:\large_events.csv": Unknown error ----->>>Please note this error!!! 时间:4.558 ms postgres=# select version(); version ------------------------------------------------------------ PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit ----->>>>PostgreSQL version is 12.1 (1 行记录) 时间:0.280 ms postgres=# Please note: 1. d:\large_events.csv this file is large 2GB。 2. the software “postgresql-12.1-1-windows-x64.exe” is downloaded from enterprisedb website.
В списке pgsql-bugs по дате отправления: