dbcli / dbcli/pgcli

Use an incorrect copy command syntax copy instead of \copy and cannot quit app.

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

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.