Thread: 2 errors when accessing schema->public

2 errors when accessing schema->public

From

"Horacio de Oro"

Date:

10 December 2007, 12:45:38

Hi!
I've installed PGadmin III 1.6.3 (downloaded from the pgadmin site) for working with PostgreSql 8.3beta4. When going to "Schemas -> public" for the first time, or when doing a "refresh" on "Schemas -> public" I get 2 errors:

ERROR 1:
An error has occurred:
ERROR: column op.oprlsortop does not exist
LINE 12: LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop

ERROR 2:
An error has occurred:
ERROR: column "opcamid" does not exist
LINE 3: JOIN pg_am am ON am.oid=opcamid

In the server, the "adminpack" was installed correctly. I'm working on Ubuntu 7.04.
Maybe this "problem report" could be useful...

Thanks!
Horacio

--
Horacio de Oro <hgdeoro@gmail.com>
http://www.bamboo-it.com.ar/
Tel. (0351) 423-2067
Cel. (0351) 153-452573

Re: 2 errors when accessing schema->public

From

Dave Page

Date:

10 December 2007, 12:52:17

Horacio de Oro wrote:
> Hi!
> I've installed PGadmin III 1.6.3 (downloaded from the pgadmin site) for
> working with PostgreSql 8.3beta4. When going to "Schemas -> public" for
> the first time, or when doing a "refresh" on "Schemas -> public" I get 2
> errors:

pgAdmin 1.6.x doesn't support PostgreSQL 8.3.x. Upgrade to 1.8.

Regards, Dave.