Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BB1139FB9F4 for ; Tue, 20 Mar 2007 15:47:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 13117-02 for ; Tue, 20 Mar 2007 15:47:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp107.mail.mud.yahoo.com (smtp107.mail.mud.yahoo.com [209.191.85.217]) by postgresql.org (Postfix) with SMTP id 3328E9FB5B2 for ; Tue, 20 Mar 2007 15:47:42 -0300 (ADT) Received: (qmail 96833 invoked from network); 20 Mar 2007 18:47:41 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=dhTy28JsmHM+4wDtopJnotzQMbf3P1dGT46J+PlC36dWZUx3OMgGHuGXLm6lgZc/OGi8rrQ0i+BtPPzVJob1yqNSUmFeEsGVJVH79brE1E1EM1dfKk/WDR6DYMJiExkR7trjAEFY90SZqclCvo6sak6CbzxjjptwRZ0Vy+Lw3qE= ; Received: from unknown (HELO ?10.90.2.103?) (burbello3000@200.103.143.8 with plain) by smtp107.mail.mud.yahoo.com with SMTP; 20 Mar 2007 18:47:40 -0000 X-YMail-OSG: A6QzTUoVM1lgT40Hp9kYNzbKK00ozUrLHZmBSA9MlC6.UMXT7jJ4qeEadDIqqvoeBF_ZxiBRw.SkIteb6CjkKVOgbqGu3RHg.kuVeIvGWcHedxEft0hZzXaShLSHXIqDELdgMlAFxZ9v.iI- Message-ID: <46002C3D.5020602@yahoo.com.br> Date: Tue, 20 Mar 2007 15:47:25 -0300 From: "Alexander B." User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Trigger using Tsearch Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/134 X-Sequence-Number: 24958 Hi for all, I just installed Tsearch and was trying to configure automatic update on such table using trigger and procedure. But I get error on inserting data on the table. Could you help me to find out what I am wronging? #### Procedure created: create or replace function fn_atualiza_tsearch_cid_endereco() returns trigger as ' BEGIN update tb_cep_cidade_endereco set cue_idx_endereco = to_tsvector(''default_portuguese'', coalesce(to_ascii(NEW.cue_logradouro, ''LATIN1''), '''')) where cue_cod_endereco = new.cue_cod_endereco and cue_cep = new.cue_cep; RETURN NEW; END; ' LANGUAGE plpgsql; $ created sucessfully; #### Trigger created: create trigger trg_atualiza_tsearch_cid_endereco after insert or update on tb_cep_cidade_endereco for each row execute procedure fn_atualiza_tsearch_cid_endereco(); $ created sucessfully; ### Insert data INSERT INTO tb_cep_cidade_endereco . . . and returns: >[Error] Script lines: 1-3 -------------------------- Um erro de E/S ocorreu ao enviar para o processo do servidor. An error I/O occurred sending to the server process _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/