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

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 vary

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

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 w

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 thr

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 Sulliva

[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