PostgreSQL on Solaris: Changing Compilers During Point Upgrade

From: "Thomas F(dot) O'Connell" <tf(at)o(dot)ptimized(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
Date: 2007-02-06 15:43:01
Message-ID: 9F2CF4BF-5EF4-4FFE-9475-8526BD632E77@o.ptimized.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 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.

Is changing compilers under postgres on the same platform without a
dump/reload a Bad Idea?

More important: Has this risked any catastrophic data corruption? If
we just switch to a gcc 8.2.2, will we be fine?

--
Thomas F. O'Connell

optimizing modern web applications
: for search engines, for usability, and for performance :

http://o.ptimized.com/
615-260-0005

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-06 15:45:23 Re: create operator class problem
Previous Message Ümit Öztosun 2007-02-06 15:41:01 Re: Very strange error