Обсуждение: Installed pgadmin3-1.4.3 with 8.3.1 database..errors

Поиск
Список
Период
Сортировка

Installed pgadmin3-1.4.3 with 8.3.1 database..errors

От
Barbara Stephenson
Дата:
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

Re: Installed pgadmin3-1.4.3 with 8.3.1 database..errors

От
Steve Atkins
Дата:
On May 22, 2008, at 6:38 AM, Barbara Stephenson 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?

I'd guess it's that you're using an obsolete version of pgadmin that
doesn't know about system changes. 1.8.2 is the current version, I
think.

Cheers,
   Steve

>
>
>
> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Re: Installed pgadmin3-1.4.3 with 8.3.1 database..errors

От
Devrim GÜNDÜZ
Дата:
Hi,

On Thu, 2008-05-22 at 09:38 -0400, Barbara Stephenson wrote:

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

You can find up2date version here:

http://yum.pgsqlrpms.org/8.3/redhat/rhel-4-x86_64/repoview/pgadmin3.html

or here:

http://yum.pgsqlrpms.org/8.3/redhat/rhel-4-i386/repoview/pgadmin3.html

depending on your arch.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Вложения