Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36996=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1ToQTB-0007Y4-1B
	for pgsql-sql@arkaria.postgresql.org; Fri, 28 Dec 2012 03:18:49 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36996=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1ToQTA-0007ZG-15
	for pgsql-sql@arkaria.postgresql.org; Fri, 28 Dec 2012 03:18:48 +0000
Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <GavinFlower@archidevsys.co.nz>) id 1ToGDN-0003vv-FR
	for pgsql-sql@postgresql.org; Thu, 27 Dec 2012 16:21:49 +0000
Received: from mbx.knossos.net.nz ([202.160.48.10])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <GavinFlower@archidevsys.co.nz>) id 1ToGDF-0000Dg-Qf
	for pgsql-sql@postgresql.org; Thu, 27 Dec 2012 16:21:49 +0000
Received: from [10.1.1.3] (60-234-150-59.bitstream.orcon.net.nz
	[60.234.150.59]) (authenticated bits=0)
	by mbx.knossos.net.nz (8.14.4/8.14.4) with ESMTP id qBRGLUYD027120
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT);
	Fri, 28 Dec 2012 05:21:31 +1300
Message-ID: <50DC758D.9010309@archidevsys.co.nz>
Date: Fri, 28 Dec 2012 05:21:33 +1300
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
Organization: ArchiDevSys
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: johnf@jfcomputer.com
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: strange corruption?
References: <50DC5AD0.3040507@jfcomputer.com>
In-Reply-To: <50DC5AD0.3040507@jfcomputer.com>
Content-Type: multipart/alternative;
	boundary="------------090206040803080608040309"
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------090206040803080608040309
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 28/12/12 03:27, John Fabiani wrote:
> Hi,
> I have the following statement in a function.
>
>     UPDATE orderseq
>     SET orderseq_number = (orderseq_number + 1)
>     WHERE (orderseq_name='InvcNumber');
>
> All it does is update a single record by incrementing a value (int).
>
> But it never completes.  This has to be some sort of bug.  Anyone have 
> a thought what would cause this to occur.  To my knowledge it was 
> working and does work in other databases.
>
> Johnf
>
>
It might help if you give the table definition.

Definitely important: is the exact version of PostgreSQL used, and the 
operating system.


Cheers,
Gavin

--------------090206040803080608040309
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">On 28/12/12 03:27, John Fabiani wrote:<br>
    </div>
    <blockquote cite="mid:50DC5AD0.3040507@jfcomputer.com" type="cite">Hi,
      <br>
      I have the following statement in a function.
      <br>
      <br>
      &nbsp;&nbsp;&nbsp; UPDATE orderseq
      <br>
      &nbsp;&nbsp;&nbsp; SET orderseq_number = (orderseq_number + 1)
      <br>
      &nbsp;&nbsp;&nbsp; WHERE (orderseq_name='InvcNumber');
      <br>
      <br>
      All it does is update a single record by incrementing a value
      (int).
      <br>
      <br>
      But it never completes.&nbsp; This has to be some sort of bug.&nbsp; Anyone
      have a thought what would cause this to occur.&nbsp; To my knowledge it
      was working and does work in other databases.
      <br>
      <br>
      Johnf
      <br>
      <br>
      <br>
    </blockquote>
    <font size="-1">It might he<font size="-1">lp if you give the table
        definition</font></font>.<br>
    <br>
    Definitely important: is the exact version of PostgreSQL used, and
    the operating system.<br>
    <br>
    <br>
    Cheers,<br>
    Gavin
  </body>
</html>

--------------090206040803080608040309--