| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | kes-kes(at)yandex(dot)ru |
| Subject: | BUG #15192: Implement option to use columns order defined at CSV |
| Date: | 2018-05-10 11:18:04 |
| Message-ID: | 152595108433.1481.5280132477337920465@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15192
Logged by: Eugen Konkov
Email address: kes-kes(at)yandex(dot)ru
PostgreSQL version: 9.6.1
Operating system: SMP Debian 4.9.82-1+deb9u3
Description:
While dumping/restore data I faced into problem that column order are
different on different servers.
Restoring the data
COPY tariff_details FROM STDIN WITH( FORMAT CSV, HEADER )
cause error:
ERROR: null value in column "periodic" violates not-null constraint
DETAIL: Failing row contains (17, 1, Setup fee, 5.000000000000000000,
null, f, null, 0).
CONTEXT: COPY tariff_details, line 2: "17,1,Setup
fee,5.000000000000000000,,f,,0"
To work around this problem I use next makefile:
dbrestoretable: export PGPASSWORD = ${DB_PASS}
dbrestoretable:
line=$$(head -n 1 ${APP_ROOT}/db/${TABLE}.dump.csv)
@cat ${APP_ROOT}/db/${TABLE}.dump.csv | \
psql -h ${DB_HOST} -p ${DB_PORT} -U ${DB_USER} ${DB_NAME} -c \
"BEGIN;COPY ${TABLE}($$line) FROM STDIN WITH( FORMAT CSV, HEADER
);COMMIT;" ||:
Implement option to force postgres to use columns order from CSV
For details: https://stackoverflow.com/q/50271162/4632019
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-05-10 13:36:39 | PostgreSQL 2018-05-10 Security Update Release |
| Previous Message | Michael Paquier | 2018-05-10 09:04:53 | Re: the postgres process is not killed when the postmaster is killed |