From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 31975 invoked by alias); 1 Nov 2004 16:52:39 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 31954 invoked from network); 1 Nov 2004 16:52:37 -0000 Received: from unknown (HELO Mercury.turbocorp.com) (198.212.166.40) by sourceware.org with SMTP; 1 Nov 2004 16:52:37 -0000 Received: from [198.212.166.61] (Voyager.turbocorp.com [198.212.166.61]) by Mercury.turbocorp.com (8.12.8/8.12.8) with ESMTP id iA1GqNC1029646; Mon, 1 Nov 2004 11:52:24 -0500 Message-ID: <418669C6.4090709@turbocorp.com> Date: Mon, 01 Nov 2004 16:52:00 -0000 From: John Allgood User-Agent: Mozilla Thunderbird 0.8 (X11/20041009) MIME-Version: 1.0 To: Tom Lane , rhdb@sources.redhat.com Subject: Re: Problems with RHDB 3.0 References: <41862A46.6030400@turbocorp.com> <14573.1099326986@sss.pgh.pa.us> In-Reply-To: <14573.1099326986@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Turbo-MailScanner-Information: Please contact the ISP for more information X-Turbo-MailScanner: Found to be clean X-Turbo-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=0.077, required 6, TW_PG 0.08) X-MailScanner-From: john@turbocorp.com X-SW-Source: 2004-q4/txt/msg00003.txt.bz2 Hello Again This was a problem you had responded to on the postgres novice list. You had responded back to Terry Tucker it was an array question dealing with triggers. Terry had ask me to check about the next version of Redhat Database since that is the version we had decided to go with. I appreciate you feedback on this. Any other comments are welcome. Below is the email to the novice list just to refresh you memory. Thanks Again Subject: [NOVICE] Array Question From: Terry Lee Tucker Date: Fri, 29 Oct 2004 21:08:38 -0400 To: pgsql-novice@postgresql.org Greetings: I have a customer history table that contains several integer and decimal arrays for recording sales and load count information for each of the 12 months. I'm trying to modify one of the arrays in a pre-update trigger. I'm looping as in: for x in 1..12 loop array[x] = ; . . . end loop; This will not compile. I get the following error: ERROR: syntax error at or near "[" If I comment that line out, all works well. Any ideas? Thanks... Tom Lane wrote: >John Allgood writes: > > >> We have discovered a problem with plpgsql on Redhat Database 3.0 The >>problem is fixed with Postgres 7.4. Is there is a new version of Redhat >>Database on the horizon and what can we expect for the new version. "7.4 >>or 8.0.". We are trying to get an idea on what direction we need to go in. >> >> > >Well, the road map looks like this: > >RHEL3 will use rh-postgresql 7.3.* until end of life; an upgrade to a >new major Postgres version is out of the question because of our >backward-compatibility requirements for that product. > >Fedora Core 3 (to become RHEL4) currently uses Postgres 7.4.*, and I am >surely hoping that PG 8.0 is out in time that it can be the long-term- >supported version for RHEL4. Note that we have dropped the "RHDB" >branding in this version and gone back to calling it plain PostgreSQL. > >As far as your immediate problem goes, depending on what the issue is, >it might or might not be feasible to back-port a fix into rh-postgresql >7.3. You didn't give any details... > > regards, tom lane > Red Hat Database project > > >