Closed
Description
Executing command (DB server is on the same machine):
pg_dump -F custom database > new_shiny.dump
Getting error:
pg_dump: [archiver (db)] query failed: ERROR: improper qualified name (too many dotted names): id.tracker_id.data.evented_at.created_at.ambulance_status_id.in_zone.is_stop
LINE 1: COPY public.tracker_points (id, tracker_id, data, evented_at...
^
pg_dump: [archiver (db)] query was: COPY public.tracker_points (id, tracker_id, data, evented_at, created_at, ambulance_status_id, in_zone, is_stop) TO stdout;
And pg_dump is immediately finished with non-zero exit code.
Where id.tracker_id.data.evented_at.created_at.ambulance_status_id.in_zone.is_stop
is just a list of columns of tracker_points
table joined with dot.
PostgreSQL 9.5.4 with pg_pathman 1.1, 1.1.1 and master_improved_planning
branch.
Database is the same as in #41