target-postgres

target-postgres copied to clipboard

invalid_records_* doesn't ignore psycopg2 encoding errors

1

I'm getting the following error: `target_postgres.exceptions.PostgresError: ('Exception writing records', QueryCanceled("COPY from stdin failed: error in .read() call: UnicodeEncodeError 'utf-8' codec can't encode character '\\udc81' in position 184: surrogates not allowed\nCONTEXT:...

seajhawk

Broken Pipe - Symbol not found: _PQbackendPID

1

There is dependency mismatch between target-postgres and psycopg2 library. - target-postgres needs psycopg2==2.7.5 - singer-target-postgres needs psycopg2==2.8.5 From web sources, I guess the postgresql driver issue (Broken Pipe - Symbol...

catherine-jayapandian

Hello, I am getting following issue on psycopg2 package when trying to install the target: ``` pip install singer-target-postgres Collecting singer-target-postgres Using cached singer_target_postgres-0.2.4-py3-none-any.whl (46 kB) Collecting arrow==0.15.5 Using cached...

mspedalettiHM

If the upstream tap changes schema, for instance if the key properties are modified, the target will fail with a confusing message such as: ``` target_postgres.exceptions.PostgresError: ('Exception writing records', PostgresError("`key_properties`...

laurentS

Website target pip install documentation issue

1

Hi all, On the website, it says target-postgres**ql** instead of target-postgres: https://www.singer.io/target/postgresql/ this results in an error when a user tries to run the command. The "View the Repo" button...

naxels