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:mmonc...@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.lit...@orbitz.com<mailto:douglas.lit...@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. merlin
