Error after upgrade 8.1.4 to 8.4.2

am 14.07.2010 15:48:16 von eduardoreis

Esta é uma mensagem em várias partes no formato MIME.

------=_NextPart_000_0012_01CB2342.10CF0ED0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.=3D) $1 FOR SHARE OF x

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

ERROR: permission denied for schema sch_sis
SQL state: 42501

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

Can anyone help me on this error

Thanks a lot

Eduardo
------=_NextPart_000_0012_01CB2342.10CF0ED0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http-equiv=3DContent-Type>

15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">

Hi,

tc=3D"ap=F3s fazer uma atualização de vers=E3o o seguinte erro =
passou a ocorrer."=20
uc=3D"after doing an upgrade the following error started to occur."=20
closure_uid_kmi2r=3D"75">After doing an upgrade the following error =
started to=20
occur.

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

********** Error =
**********

ERROR: permission denied for schema =
sch_sis
SQL=20
state: 42501

configuração ?"=20
uc=3D"may be some configuration? "=20
closure_uid_kmi2r=3D"187"> title=3D""=20
tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"=20
closure_uid_kmi2r=3D"188">

style=3D"BACKGROUND-COLOR: #fff"=20
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."=20
uc=3D"I checked that the scheme has the permissions. " =
closure_uid_kmi2r=3D"128">I=20
checked that the scheme has the permissions.

style=3D"BACKGROUND-COLOR: #fff"=20
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."=20
uc=3D"I checked that the scheme has the permissions. "=20
closure_uid_kmi2r=3D"128"> configuração ?"=20
uc=3D"may be some configuration? " =
closure_uid_kmi2r=3D"187">May be some=20
configuration? style=3D"BACKGROUND-COLOR: #fff">

style=3D"BACKGROUND-COLOR: #fff"=20
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."=20
uc=3D"I checked that the scheme has the permissions. "=20
closure_uid_kmi2r=3D"128"> tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"=20
closure_uid_kmi2r=3D"135">Can anyone help me on this=20
error

tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"=20
closure_uid_kmi2r=3D"135">

tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"=20
closure_uid_kmi2r=3D"135">Thanks a lot

Eduardo

------=_NextPart_000_0012_01CB2342.10CF0ED0--