Unable to perform alterations more than once on a table.

[sunilgandipadala]

Hi @shayonj ,

I found, that there is an issue with performing the pg-osc command more than once, when we didn't use --drop. When I haven't used --drop and ran the command, it works fine and created a old table. Now, again I tried to run the command on the same table, but now its raising an error as table already exits as below.
ERROR: relation "pgosc_op_table_employees" already exists (PG::DuplicateTable)
Solution:
I guess, when renaming the old table, you may have give the name format as "pgosc_op_table_{tablename}"--> this will cause the error, To resolve this, You may change the format to "pgosc_op_table_{tablename}_{index}"

Here index/id can be a unique value.

[sunilgandipadala]

I guess, this has to be updated as
Store.set(:old_primary_table, "pgosc_op_table_#{client.table.downcase}_#{pgosc_identifier}")

Which making the feature fails.

[shayonj]

I am curious, why wouldn't you want to use --drop before the next run? Is it for some analysis sort of thing or perhaps some fail safe mode?