Autodesk / pgbelt

Pgbelt is a CLI tool used to manage Postgres data migrations from beginning to end, for a single database or a fleet, leveraging pglogical replication.
Apache License 2.0
18 stars 5 forks source link

fix: support for capital letters in sequence names #548

Closed vjeeva closed 2 months ago

vjeeva commented 2 months ago

Problem:

Capitals in Sequence Names would yield errors like relation "non_public_schema.users_id_seq" does not exist for a sequence named userS_id_seq. Previously we thought the integration test covered this but the schema SQL didn't wrap the sequence names in quotes.

Solved it in this PR! Integration test works!