pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: f的梦 <1728565484@qq.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: Report bug!
Date: Mon, 6 Jan 2020 14:52:38 +0100
Message-ID: <20200106135238.rkrt6kskppg4unss@development> (raw)
In-Reply-To: <tencent_11484D848606BA3C8A19689C27389B224306@qq.com>
References: <tencent_11484D848606BA3C8A19689C27389B224306@qq.com>

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?
>
>
>```
>&nbsp;\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





view thread (5+ messages)  latest in thread

Message-ID: <20200106135238.rkrt6kskppg4unss@development>
Permalink:  ../20200106135238.rkrt6kskppg4unss@development/
Also on:    postgresql.org/message-id/20200106135238.rkrt6kskppg4unss@development

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, 1728565484@qq.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: Report bug!
  In-Reply-To: <20200106135238.rkrt6kskppg4unss@development>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox