Re: [ADMIN] installation of postgresql8.0.1 on Solaris 10

2005-11-21 Thread Politowicz, Phil
Olive, You must compile from source, as Mike has mentioned; 8.0.1 is not certified on Solaris 10, and you must limit your functionality. If you can at least try 8.0.3, please do so. If you compile from source, check your gcc version. It must be at least as recent as that recommended in the release

[ADMIN] primary key constraint violation

2005-08-07 Thread Politowicz, Phil
I am running a 7.4.3 postgreSQL database on RHEL 3. I have encountered two cases where tables have multiple key values, in violation of a primary key constraint. I discovered this after receiving SQL exceptions, where the primary key constraint was all of a sudden being enforced again. This may be