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@gmail.com]
Sent: Wednesday, March 06, 2013 9:47 AM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general@postgresql.org)
Subject: Re: [GENERAL] FW: statement failure
On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> 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.