Thread: Report bug!

Report bug!

From
"f的梦"
Date:
I want to report a bug for PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit

I can't create account, so I can only send it here.

/copy command will not trigger increament of a table's pk.

How I get this problem?

```
 \copy one_off_coupon(payload,tag, expire_at) from '/tmp/ldj.csv' delimiter as ',' csv quote as '"';
```

```
select * from one_off_coupon
```

The list is success loaded and id correct ranged 1-7000.

OK, Here is the problem:

When I try `insert into one_off_coupon(payload) values('111')`, it reports error `pk brabra conflict`.

Then I print
```
select nextval('one_off_coupon_id_seq');
```
It is `47`,so far away from 7000.

!!!!!!!!!!!!!

Re: Report bug!

From
Tomas Vondra
Date:
On Mon, Jan 06, 2020 at 06:22:53PM +0800, f的梦 wrote:
>I want to report a bug for PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
4.8.5-4),64-bit
 
>
>I can't create account, so I can only send it here.
>
>
>/copy command will not trigger increament of a table's pk.
>
>
>How I get this problem?
>
>
>```
> \copy one_off_coupon(payload,tag, expire_at) from '/tmp/ldj.csv' delimiter as ',' csv quote as '"';
>```
>
>
>```
>select * from one_off_coupon
>```
>
>
>The list is success loaded and id correct ranged 1-7000.
>
>
>OK, Here is the problem:
>
>
>When I try `insert into one_off_coupon(payload) values('111')`, it reports error `pk brabra conflict`.
>
>
>Then I print
>```
>select nextval('one_off_coupon_id_seq');
>```
>It is `47`,so far away from 7000.
>

I think we need to see '\d one_off_coupon'.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services