Use an incorrect copy command syntax copy instead of \copy and cannot quit app.
- Dominant language
- Python
- Stars
- 13.4k
- Forks
- 612
- Avg merge
- 6d 14h
- Merged PRs (30d)
- 10
Description
Use an incorrect copy command syntax copy instead of \copy and cannot quit app after that:
```
Server: PostgreSQL 14.15
Version: 4.3.0
Home: http://pgcli.com
simplifi-live> copy (select id from transcoding_formats order by id) to stdout csv;
COPY cannot be used with this method; use copy() instead
Time: 0.043s
simplifi-live> quit
A transaction is ongoing. Choose `c` to COMMIT, `r` to ROLLBACK, `a` to abort exit. [a]: r^M
```
Contributor guide
Research direction
Reproduce the session shown in the issue with PostgreSQL 14.15 and pgcli 4.3.0, starting with the COPY command and then the quit flow. Trace how the CLI handles `copy (...) to stdout csv` and the ongoing transaction prompt; done means the command guidance and subsequent exit behavior are correct and covered by a regression test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- cli, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100