Postgres Pro
Downloads
Home   >   mailing lists

Error after upgrade 8.1.4 to 8.4.2 - Mailing list pgsql-admin

From Eduardo Sá dos Reis
Subject Error after upgrade 8.1.4 to 8.4.2
Date
Msg-id 7249A5EC4D7B46AE9FE846D289800F1F@P01140047
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Gabriele Bartolini
Date:
Subject: Re: upgrade postgres 8.1.21 to version 8.3.6
Next
From: Silvio Brandani
Date:
Subject: Re: upgrade postgres 8.1.21 to version 8.3.6