From: | f的梦 <1728565484(at)qq(dot)com> |
---|---|
To: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Report bug! |
Date: | 2020-01-06 10:22:53 |
Message-ID: | tencent_11484D848606BA3C8A19689C27389B224306@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
!!!!!!!!!!!!!
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2020-01-06 13:52:38 | Re: Report bug! |
Previous Message | Thomas Kellerer | 2020-01-06 09:12:06 | Re: BUG #16192: Function to_char(date,'IW') return incorrect value for last days of a year |