[GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Thomas F. O'Connell
I'm working on a system where postgres 8.2.1 was built from source on Solaris 10 using gcc. Based on a number of recommendations, we decided to rebuild postgres Sun Studio cc. Without changing platforms, I wouldn't've expected the compiler to make a difference, but we just built 8.2.2 from

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Andrew Sullivan
On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: DETAIL: Table has type character varying, but query expects character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release. A -- Andrew Sullivan

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Thomas F. O'Connell
On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: DETAIL: Table has type character varying, but query expects character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release. Is this the other

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Jim Nasby
On Feb 6, 2007, at 9:54 AM, Andrew Sullivan wrote: On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: DETAIL: Table has type character varying, but query expects character varying. In another thread, someone else is reporting this too. I'm wondering whether something went

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Tom Lane
Thomas F. O'Connell [EMAIL PROTECTED] writes: but we just built 8.2.2 from source using cc, and now we're seeing this type of error in the logs: ERROR: attribute 3 has wrong type DETAIL: Table has type character varying, but query expects character varying. This has nothing to do with

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Thomas F. O'Connell
On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote: Thomas F. O'Connell [EMAIL PROTECTED] writes: but we just built 8.2.2 from source using cc, and now we're seeing this type of error in the logs: ERROR: attribute 3 has wrong type DETAIL: Table has type character varying, but

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Bruce Momjian
Thomas F. O'Connell wrote: On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote: Thomas F. O'Connell [EMAIL PROTECTED] writes: but we just built 8.2.2 from source using cc, and now we're seeing this type of error in the logs: ERROR: attribute 3 has wrong type DETAIL: