jackc / jackc/pgx

error occurred when run select query on remote db

Open
#1,139 6 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.