Error after upgrade 8.1.4 to 8.4.2

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.
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16588"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"
name=3D"Compose message area">
<DIV><FONT size=3D2 face=3DArial>Hi,</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><SPAN id=3Dresult_box class=3Dshort_text><SPAN title=3D""
tc=3D"ap=F3s fazer uma atualiza=E7=E3o de vers=E3o o seguinte erro =
passou a ocorrer."
uc=3D"after doing an upgrade the following error started to occur."
closure_uid_kmi2r=3D"75">After doing an upgrade the following error =
started to
occur.</SPAN></SPAN></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial>ERROR:  permission denied for =
schema
sch_sis<BR>LINE 1: SELECT 1 FROM ONLY "sch_sis"."tb_almo" x WHERE
"c...<BR>          &nbs=
p;            =
;   
^<BR>QUERY:  SELECT 1 FROM ONLY "sch_sis"."tb_almo" x WHERE =
"cd_almo"
OPERATOR(pg_catalog.=3D) $1 FOR SHARE OF x</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial>********** Error =
**********</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial>ERROR: permission denied for schema =
sch_sis<BR>SQL
state: 42501<BR></FONT></DIV>
<DIV><FONT face=3DArial><SPAN title=3D"" tc=3D"pode ser alguma =
configura=E7=E3o ?"
uc=3D"may be some configuration? "
closure_uid_kmi2r=3D"187"></SPAN></FONT><FONT face=3DArial><SPAN =
title=3D""
tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"
closure_uid_kmi2r=3D"188"></SPAN></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3><SPAN =
style=3D"BACKGROUND-COLOR: #fff"
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."
uc=3D"I checked that the scheme has the permissions. " =
closure_uid_kmi2r=3D"128">I
checked that the scheme has the permissions. </SPAN></FONT></FONT></DIV>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3><SPAN =
style=3D"BACKGROUND-COLOR: #fff"
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."
uc=3D"I checked that the scheme has the permissions. "
closure_uid_kmi2r=3D"128"><SPAN title=3D"" tc=3D"pode ser alguma =
configura=E7=E3o ?"
uc=3D"may be some configuration? " =
closure_uid_kmi2r=3D"187">May be some
configuration?<BR
style=3D"BACKGROUND-COLOR: #fff"></SPAN></SPAN></FONT></FONT></DIV>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3><SPAN =
style=3D"BACKGROUND-COLOR: #fff"
title=3D"" tc=3D"Eu chequei que o esquema possui as permiss=F5es."
uc=3D"I checked that the scheme has the permissions. "
closure_uid_kmi2r=3D"128"></SPAN><SPAN title=3D""
tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"
closure_uid_kmi2r=3D"135">Can anyone help me on this
error</SPAN></FONT></FONT></DIV>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3><SPAN title=3D""
tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"
closure_uid_kmi2r=3D"135"></SPAN></FONT></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3><SPAN title=3D""
tc=3D"Algu=E9m pode me ajudar sobre este erro" uc=3D"Can anyone help me =
on this error"
closure_uid_kmi2r=3D"135">Thanks a lot</SPAN></FONT></DIV></FONT>
<DIV><FONT size=3D2 face=3DArial></FONT> </DIV>
<DIV><FONT size=3D2 face=3DArial>Eduardo </FONT></DIV></BODY></HTML>

------=_NextPart_000_0012_01CB2342.10CF0ED0--
eduardoreis [ Mi, 14 Juli 2010 15:48 ] [ ID #2044455 ]
Datenbanken » gmane.comp.db.postgresql.admin » Error after upgrade 8.1.4 to 8.4.2

Vorheriges Thema: upgrade postgres 8.1.21 to version 8.3.6
Nächstes Thema: cache lookup for operator ...