error occurred when run select query on remote db
- Dominant language
- Go
- Stars
- 14.3k
- Forks
- 1.1k
- Avg merge
- 6d 9h
- Merged PRs (30d)
- 11
Description
I tried to run query on remote postgresql db on AWS.
but after run query, rows.Next() return false, and rows.Err() says `scany: rows final error: ERROR: prepared statement "lrupsc_1_0" does not exist (SQLSTATE 26000)`.
of course I run complex query, so I tried with simple query such as "select * from users" but still same error.
Please help me how to fix it.
Contributor guide
Research direction
Start by reproducing the reported select query against the remote PostgreSQL database on AWS and inspect the rows.Err() result, including the prepared-statement error. The issue is resolved when the cause of the missing prepared statement is identified and a verified fix or clear usage guidance is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, go, postgresql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100