Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3DF3D632C0A for ; Wed, 14 Jul 2010 10:58:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 19073-10 for ; Wed, 14 Jul 2010 13:58:49 +0000 (UTC) X-Greylist: delayed 00:10:29.474375 by SQLgrey-1.7.6 Received: from webshield01.pjf.mg.gov.br (187-072-160-221.static.ctbctelecom.com.br [187.72.160.221]) by mail.postgresql.org (Postfix) with SMTP id 9EA4E632B68 for ; Wed, 14 Jul 2010 10:58:50 -0300 (ADT) Received: from (unknown [192.168.254.5]) by webshield01.pjf.mg.gov.br with smtp id 1958_48ea_71276052_8f4e_11df_87ab_002219d6be93; Wed, 14 Jul 2010 10:48:16 -0300 Received: from localhost (localhost [127.0.0.1]) by internet01.pjf.mg.gov.br (Postfix) with ESMTP id 9D5976BCCE for ; Wed, 14 Jul 2010 10:45:47 -0300 (BRT) X-Virus-Scanned: Debian amavisd-new at pjf.mg.gov.br Received: from internet01.pjf.mg.gov.br ([127.0.0.1]) by localhost (internet01.pjf.mg.gov.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uc+fVQXA72jW for ; Wed, 14 Jul 2010 10:45:47 -0300 (BRT) Received: from P01140047 (unknown [10.0.12.49]) by internet01.pjf.mg.gov.br (Postfix) with SMTP id 2B9886BCCB for ; Wed, 14 Jul 2010 10:45:47 -0300 (BRT) Message-ID: <7249A5EC4D7B46AE9FE846D289800F1F@P01140047> From: =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= To: Subject: Error after upgrade 8.1.4 to 8.4.2 Date: Wed, 14 Jul 2010 10:48:16 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0012_01CB2342.10CF0ED0" X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Mailer: Microsoft Windows Live Mail 14.0.8089.726 X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726 X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 2 X-NAI-Spam-Score: 0.5 X-NAI-Spam-Rules: 2 Rules triggered FROM_NAME=0.5, RV3578=0 X-NAI-Spam-Version: 2.2.0.9286 : core <3578> : streams <512337> : uri <63291 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.802 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_FONT_LOW_CONTRAST=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201007/65 X-Sequence-Number: 35084 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
Hi,
 
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
 
I=20 checked that the scheme has the permissions.
May be some=20 configuration?
Can anyone help me on this=20 error
 
Thanks a lot
 
Eduardo
------=_NextPart_000_0012_01CB2342.10CF0ED0--