jakob / jakob/Postico

"E" character appears when copy special -> copy insert statement

Open
#480 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

## What did you do?
Copy and paste the insert statement from the contextual menu "Copy Insert Statement"
![screen shot 2018-01-09 at 12 37 28](https://user-images.githubusercontent.com/38052/34706427-49eba336-f53a-11e7-890a-f70f1c4428e2.png)

## What did you expect to happen?

I paste the source code to the editor, and the "E" char appears.

```
INSERT INTO "public"."mall_settings"("mall_setting_references_key","mall_id","value")
VALUES
(E'receipt_date_subtitle',E'0UBtU-Qs',E'Loyalty System'),
(E'redeem_format',E'0UBtU-Qs',E'RED-{timestamp}-{code}-{username}'),
(E'redeemevoucher_prefix',E'0UBtU-Qs',E'CRM-EV');
```

## What software versions are you using?

Postico version:
(select "About Postico" from the Postico menu)

macOS version:
10.13.2

PostgreSQL version:
PostgreSQL 9.5.4 on x86_64-apple-darwin16.0.0, compiled by Apple LLVM version 8.0.0 (clang-800.0.38), 64-bit

Postico 1.2.3

Thank you.

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is named. Start by reproducing the contextual-menu “Copy Insert Statement” action with the reported PostgreSQL and Postico versions, then inspect the code path that generates the copied SQL. Done means the pasted INSERT statement no longer contains unexpected E prefixes and the behavior is covered by a regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.