MagicStack / MagicStack/asyncpg

PostgresSyntaxErrror while copy_records_to_table method call

Open
#932 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
8.1k
Forks
468
PR merge metrics
No merged PRs in 30d

Description

* **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](https://github.com/magicstack/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

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at the copy_records_to_table entry point and try to reproduce the reported syntax error near "STDIN" with asyncpg 0.25.0, Python 3.9, and the stated Redshift environment. The report needs a complete reproducible case and a maintainer-confirmed outcome before a newcomer can know whether the result should be a fix or compatibility documentation.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.