Re: Problems with RHDB 3.0

[John Allgood <john at turbocorp dot com>]

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 <terry@esc1.com>
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] = <some_value>;
	.
	.
	.
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 <john@turbocorp.com> 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
>
>