Installed pgadmin3-1.4.3 with 8.3.1 database..errors

Started by Barbara Stephensonalmost 18 years ago4 messagesgeneral
Jump to latest
#1Barbara Stephenson
barbara@turbocorp.com

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

#2Steve Atkins
steve@blighty.com
In reply to: Barbara Stephenson (#1)
Re: Installed pgadmin3-1.4.3 with 8.3.1 database..errors

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

Show quoted text

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

#3Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Barbara Stephenson (#1)
Re: Installed pgadmin3-1.4.3 with 8.3.1 database..errors

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/

#4Barbara Stephenson
barbara@turbocorp.com
In reply to: Barbara Stephenson (#1)
Re: [GENERAL] Installed pgadmin3-1.4.3 with 8.3.1 database..errors

Oh Devrim,

I was advised that this topic should be under the pgadmin support. So
hopefully you are also subscribed to that.

Thanks,
Barbara

Barbara Stephenson wrote:

Hello Devrim,

When I did a rpm -ihv on he second link rpm file for redhat4-i686 it shows
I need the below:

error: Failed dependencies:
libwx_baseu-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_baseu-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686 libwx_baseu_net-2.8.so.0 is needed by
pgadmin3-1.8.2-1.rhel4.i686 libwx_baseu_net-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_baseu_xml-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_adv-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_adv-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_aui-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_aui-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_core-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_core-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_html-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_html-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_ogl-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_ogl-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_qa-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_stc-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_stc-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_xrc-2.8.so.0 is needed by pgadmin3-1.8.2-1.rhel4.i686
libwx_gtk2u_xrc-2.8.so.0(WXU_2.8) is needed by
pgadmin3-1.8.2-1.rhel4.i686

I did a locate of what I have an below is what I have:

/usr/lib/libwx_baseu_xml-2.6.so.0
/usr/lib/libwx_baseu-2.6.so.0.3.1
/usr/lib/libwx_baseu_net-2.6.so.0.3.1
/usr/lib/libwx_baseu_xml-2.6.so
/usr/lib/libwx_baseu_net-2.6.so
/usr/lib/libwx_baseu_xml-2.6.so.0.3.1
/usr/lib/libwx_baseu-2.6.so.0
/usr/lib/libwx_baseu_net-2.6.so.0
/usr/lib/libwx_baseu-2.6.so

How do I get 2.8 versions?

you wrote:

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,

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