asyncpg icon indicating copy to clipboard operation
asyncpg copied to clipboard

PostgresSyntaxErrror while copy_records_to_table method call

Open gauthamarcod opened this issue 3 years ago • 1 comments

  • asyncpg version: 0.25.0:
  • PostgreSQL version : PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.39380
  • **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install? **:no
  • Python version:3.9
  • Platform: Redshift and pycharm
  • Do you use pgbouncer?:no
  • Did you install asyncpg with pip?:yes
  • If you built asyncpg locally, which version of Cython did you use?:i dont use cython
  • Can the issue be reproduced under both asyncio and uvloop?:no

when i am trying to insert the data using copy_records_to_table i have encountered an error PostgresSyntaxErrror, and the error is ** syntax error at or near "STDIN"* i dont know what to do, i have tried all of the me

gauthamarcod avatar Jul 05 '22 21:07 gauthamarcod

Maybe it's because the version of Postgres that you're using, the library says that versions older than Postgres 9.5 may work but are not being actively tested. Can't you upgrade the version of Postgres?

odiseo0 avatar Jul 08 '22 18:07 odiseo0