Skip to content

query_poll_table is getting errors when attempting to update table #1

@brountre

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".

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