Re: interesting sequence

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: interesting sequence
Date: 2011-07-06 12:28:13
Message-ID: iv1kct$vb$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2011-07-06, Kevin Crain <kevin(dot)crain1(at)gmail(dot)com> wrote:
> That's why you need to do this inside a function. Basically just make
> an insert function for the table and have it calculate the count and
> do the insert in one transaction.

you will still get duplicates, so include code in the function to
retry if there is an error.

--
⚂⚃ 100% natural

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2011-07-06 15:53:27 ERROR: malformed record literal: "", DETAIL: Missing left parenthesis?
Previous Message Gavin Flower 2011-07-06 09:47:06 Re: interesting sequence