I don't think it's a pgAdminIII thing... The error also occurs when i
try to back up a database from psql on a Fedora machine... Suggests a
problem with PostgreSQL 8.3 i think.
--
paAdminIII reports JOIN error in schema
https://bugs.launchpad.net/bugs/208481
You received this bug notification
OK, lets wait and see
--
paAdminIII reports JOIN error in schema
https://bugs.launchpad.net/bugs/208481
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
Ah, thanks for the pointers. Indeed the Ubuntu 7.10 version of pgadmin3
is not compatible with PostgreSQL 8.3, but Ubuntu 7.10 only supports
PostgreSQL 8.2 anyway (8.3 was not yet released when Ubuntu 7.10 got
released).
Ubuntu Hardy (coming 8.04) does have pgadmin 1.8.2, so it should be
fixed
Can you please try to create a reproduction recipe? I. e. table
structures and a query which generates the error? Thank you!
** Changed in: postgresql-8.3 (Ubuntu)
Status: New = Incomplete
--
paAdminIII reports JOIN error in schema
https://bugs.launchpad.net/bugs/208481
You received this
I did nothing special.
apt-get install postgresql-8.3 pgadmin3
create a database
connect to the database using pgAdminIII.
Right after connecting you get two error dialogs.
Any refresh will reproduce the errors.
I'm not alone:
Excerpt from pgAdmin.log:
2008-03-28 23:47:33 ERROR : ERROR: column op.oprlsortop does not exist
LINE 12: LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop
^
2008-03-28 23:47:42 ERROR : ERROR: column opcamid does not exist
LINE
