Skip site navigation (1) Skip section navigation (2)

Port Bug Report: Can't add nth element of array that has n-1 elts.

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Can't add nth element of array that has n-1 elts.
Date: 1999-04-30 19:05:52
Message-ID: 199904301905.PAA83566@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Raphael Finkel
Your email address      : raphael(at)cs(dot)uky(dot)edu

Category                : runtime: back-end: SQL
Severity                : non-critical

Summary: Can't add nth element of array that has n-1 elts.

System Configuration
--------------------
  Operating System   : Linux 2.0.36 ELF Slackware

  PostgreSQL version : 6.4.2

  Compiler used      : egcs-2.90.29egcs-2.90.29

Hardware:
---------
Linux zonker 2.0.36 #2 Sun Jan 10 17:51:07 EST 1999 i686 unknown



Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
 How can I add an nth element to an array column
 that already has n-1 elements?  The UPDATE command seems to fail: 
 
         database=> UPDATE myTable 
                 SET who[2] = 'raphael' 
                 WHERE letter='alpha'; 
 
         database-> ERROR: array_set: array bound exceeded 


--------------------------------------------------------------------------

Test Case:
----------


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date

Next:From: Unprivileged userDate: 1999-04-30 19:07:49
Subject: Port Bug Report: Regexp does not allow alternation in CHECK clause
Previous:From: Bruce MomjianDate: 1999-04-30 16:34:46
Subject: Re: [PORTS] Core dump with initdb on Irix 6.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group