Error after upgrade 8.1.4 to 8.4.2

From: Eduardo Sá dos Reis <eduardoreis(at)pjf(dot)mg(dot)gov(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Error after upgrade 8.1.4 to 8.4.2
Date: 2010-07-14 13:48:16
Message-ID: 7249A5EC4D7B46AE9FE846D289800F1F@P01140047
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

After doing an upgrade the following error started to occur.

ERROR: permission denied for schema sch_sis
LINE 1: SELECT 1 FROM ONLY "sch_sis"."tb_almo" x WHERE "c...
^
QUERY: SELECT 1 FROM ONLY "sch_sis"."tb_almo" x WHERE "cd_almo" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x

********** Error **********

ERROR: permission denied for schema sch_sis
SQL state: 42501

I checked that the scheme has the permissions.
May be some configuration?

Can anyone help me on this error

Thanks a lot

Eduardo

Browse pgsql-admin by date

  From Date Subject
Next Message Silvio Brandani 2010-07-14 14:44:51 Re: upgrade postgres 8.1.21 to version 8.3.6
Previous Message Gabriele Bartolini 2010-07-14 07:50:41 Re: upgrade postgres 8.1.21 to version 8.3.6