Re: 9.6.1: INSERT with PK as serial

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.6.1: INSERT with PK as serial
Date: 2017-01-17 01:11:15
Message-ID: alpine.LNX.2.11.1701161710080.18553@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 16 Jan 2017, David G. Johnston wrote:

> Without any special effort on your part the first 40 records you try to
> insert using the default sequence are now going to fail with duplicate key
> errors.

David,

Thank you. I added them while thrashing around looking for the source of
the problem. It's now fixed.

Much appreciated,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2017-01-17 08:25:38 Is it possible to specify an ESCAPE for a wildcard search using LIKE ANY (...)
Previous Message David G. Johnston 2017-01-17 00:51:57 Re: 9.6.1: INSERT with PK as serial