Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D99CC9FA4E5 for ; Fri, 24 Nov 2006 13:45:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 45304-06 for ; Fri, 24 Nov 2006 17:45:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id D84509FA2FC for ; Fri, 24 Nov 2006 13:45:12 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so641907ugf for ; Fri, 24 Nov 2006 09:45:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=X0NZkgwvjHfGSMs0tc5fGiwx7YIUW1PBCHXCYUL2wDa3YQ9PMlvFNjf5APbsWuP/WWpFxJ2DUNbQ0liuWSbcK6cK/HdJOCz4Vzs93TTmGQ+7XCMc6TOOqxdnr6vbcwWlYUWRIJTkyB4jiUpXYrbBp1yu7v2ctQvB7DeLTSECbMI= Received: by 10.67.97.7 with SMTP id z7mr7426758ugl.1164390310470; Fri, 24 Nov 2006 09:45:10 -0800 (PST) Received: by 10.66.223.9 with HTTP; Fri, 24 Nov 2006 09:45:10 -0800 (PST) Message-ID: Date: Fri, 24 Nov 2006 14:45:10 -0300 From: "Marcelo Costa" To: pgsql-admin@postgresql.org Subject: Function ERRO after UPGRADE from 7.4 to 8.1.5 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/208 X-Sequence-Number: 23735 Hi, all I migrate my database from 7.4 to 8.1.5 and make tests with aplication but this don=B4t works fine. Some trigers don=B4t work and send to me error messages as this: Warning: pg_query(): Query failed: ERROR: INSERT is not allowed in a non-volatile function CONTEXT: SQL statement "insert into ave.ave_aluno_avaliacao_diario_historico ( codigo_ave_avaliacao , codigo_ave_aluno_caderneta , nota , presenca , falta= , data_cadastro , justificativa , codigo_usuario ) select codigo_ave_avaliaca= o , codigo_ave_aluno_caderneta , nota , presenca , falta , data_cadastro , justificativa , codigo_usuario from ave.ave_aluno_avaliacao_diario where codigo_ave_aluno_caderneta =3D $1 and codigo_ave_avaliacao =3D $2 " PL/pgSQL function "func_trg_ave_aluno_avaliacao_diario_a_iu" line 16 at SQL statement in...(.= ..) I see all trigers including func_trg_ave_aluno_avaliacao_diario_a_iu and compile this but no erros send to me. Anybory can help me or send to me any link to that it can clarify. Thanks, Marcelo Costa Secretaria Executiva de Educa=E7=E3o do Par=E1 Amaz=F4nia - Par=E1 - Brazil --=20 Marcelo Costa