Skip to content

query_poll_table is getting errors when attempting to update table #1

Description

@brountre

(.venv) PS C:\Repos\Code\Python\pgsf> python.exe .\query_poll_table.py Account

Traceback (most recent call last):
File "C:\Repos\Code\Python\pgsf\query_poll_table.py", line 275, in
main()
File "C:\Repos\Code\Python\pgsf\query_poll_table.py", line 273, in main
sync_table(args.table)
File "C:\Repos\Code\Python\pgsf\query_poll_table.py", line 232, in sync_table
pg_merge_update(td, tmp_tablename)
File "C:\Repos\Code\Python\pgsf\query_poll_table.py", line 141, in pg_merge_update
cursor.execute(sql)
psycopg2.errors.UndefinedColumn: column "IsDeleted" does not exist
LINE 5: WHERE NOT "IsDeleted"
^
HINT: Perhaps you meant to reference the column "tmp_account.isdeleted" or the column "account.isdeleted".

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions