Re: FW: statement failure

["Little, Douglas" <DOUGLAS.LITTLE@xxxxxxxxxx>]

both dev and prod are 8.2.15

Version string    PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct  3 2012 20:28:56

 

can you tell me what change in 8.3  maybe Greenplum incorporated some of the changes in their build.

 

Thanks

 

From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx]
Sent: Wednesday, March 06, 2013 9:47 AM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general@xxxxxxxxxxxxxx)
Subject: Re: [GENERAL] FW: statement failure

 

On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas <DOUGLAS.LITTLE@xxxxxxxxxx> wrote:

Hi,

 

I have a dev and prod Greenplum system (4.2.2.4) that is based on PG 8.2.15

I have a function that’s been working fine on dev, but when implemented in prod had a syntax error.

I was easily able to fix by casting, but I can’t see why the message didn’t show up on our dev machine.

 

can you double check pg version on both dev and prod.  My guess is that prod is 8.3+ -- casting rules were tightened with 8.3.

 

merlin