Skip to content

pg_restore fails because cannot drop IDENTITY COLUMN  #510

@marcotn

Description

@marcotn

Current Situation

When I run dbrestore command on postgres i get this error pg_restore: error: could not execute query: ERROR: column "id" of relation ... is an identity column HINT: Use ALTER TABLE ... ALTER COLUMN ... DROP IDENTITY instead.

Proposed Actions

Probably the the restore --clean is using the drop maybe it's just a problem with pg_restore version

System Information

No response

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions