Re: Accessing Specific Schemas

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Accessing Specific Schemas
Date: 2004-06-30 00:27:07
Message-ID: 1088555227.3266.7827.camel@stromboli
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2004-06-29 at 21:24, Cason, Kenny wrote:
> PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0.3.2-7)
> (1 row)
>
>
> Hmmm... Makes me think I'm accessing the wrong version of PostgreSQL. Does that sound likely?
>

Yes. You can get into problems if you have both an RPM version and a
compiled from source version on the same machine...

You may have accessed the RPM version when you thought you were
accessing the hand compiled one. Red Hat normally has some stuff on
there from earlier versions.

To check, select all packages, filtered by "postgres"
rpm -qa | grep postgres

You might then want to decide to de-install the earlier version, or at
least more strongly locate the one you just compiled.

Best regards, Simon Riggs

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 周仁军 2004-06-30 02:05:15 unsubscribe-digest
Previous Message Alvaro Herrera 2004-06-30 00:19:15 Re: [PATCHES] nested xacts and phantom Xids