Skip to content

pg_dump not working with partitioned table: improper qualified name (too many dotted names) #50

Closed
@Envek

Description

@Envek

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions