Обсуждение: Installed pgadmin3-1.4.3 with 8.3.1 database..errors
Hello, We have recently upgraded from 7.4.19 to 8.3.1. I am running Red Hat Enterprise Linux WS release 4 (Nahant Update 6) on my laptop and I finally was able to install pgadmin3-1.4.3. However, when I expand my databases, I get two popups. Does anyone know what that means? FIRST POPUP: An error has occured: ERROR: column op.oprlsortop does not exist LINE 12: LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop SECOND POPUP: An error has occured: ERROR: column "opcamid" does not exist LINE 3: JOIN pg_am am ON am.oid=opcamid -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30507 tel: (678)989-3020 fax: (404)935-6171 barbara@turbocorp.com www.ohlogistics.com
On Thu, May 22, 2008 at 3:21 PM, Barbara Stephenson <barbara@turbocorp.com> wrote: > Hello, > > We have recently upgraded from 7.4.19 to 8.3.1. I am running Red Hat > Enterprise Linux WS release 4 (Nahant Update 6) on my laptop and I finally > was able to install pgadmin3-1.4.3. However, when I expand my databases, I > get two popups. Does anyone know what that means? > > > FIRST POPUP: > An error has occured: > > ERROR: column op.oprlsortop does not exist > LINE 12: LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop > > SECOND POPUP: > An error has occured: > > ERROR: column "opcamid" does not exist > LINE 3: JOIN pg_am am ON am.oid=opcamid You need to upgrade pgAdmin. 1.4.3 is far too old to understand the system catalogs in PG 8.3 -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Thu, May 22, 2008 at 3:40 PM, Barbara Stephenson <barbara@turbocorp.com> wrote: > There isn't any other upgrade for redhat-4? There are RPMs at http://yum.pgsqlrpms.org/ for a variety of platforms. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
There isn't any other upgrade for redhat-4? Dave Page wrote: > On Thu, May 22, 2008 at 3:21 PM, Barbara Stephenson > > <barbara@turbocorp.com> wrote: > > Hello, > > > > We have recently upgraded from 7.4.19 to 8.3.1. I am running Red Hat > > Enterprise Linux WS release 4 (Nahant Update 6) on my laptop and I > > finally was able to install pgadmin3-1.4.3. However, when I expand my > > databases, I get two popups. Does anyone know what that means? > > > > > > FIRST POPUP: > > An error has occured: > > > > ERROR: column op.oprlsortop does not exist > > LINE 12: LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop > > > > SECOND POPUP: > > An error has occured: > > > > ERROR: column "opcamid" does not exist > > LINE 3: JOIN pg_am am ON am.oid=opcamid > > You need to upgrade pgAdmin. 1.4.3 is far too old to understand the > system catalogs in PG 8.3 -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30507 tel: (678)989-3020 fax: (404)935-6171 barbara@turbocorp.com www.ohlogistics.com