X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2770F475AFF for ; Thu, 27 Feb 2003 15:58:46 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 44716-04 for ; Thu, 27 Feb 2003 15:58:31 -0500 (EST) Received: from smtp.noos.fr (nan-smtp-05.noos.net [212.198.2.74]) by postgresql.org (Postfix) with ESMTP id B096E475FC6 for ; Thu, 27 Feb 2003 15:32:59 -0500 (EST) Received: (qmail 43453482 invoked by uid 0); 27 Feb 2003 20:32:59 -0000 Received: from unknown (HELO zimmer) ([195.132.187.98]) (envelope-sender ) by 212.198.2.74 (qmail-ldap-1.03) with SMTP for ; 27 Feb 2003 20:32:59 -0000 Message-ID: <006f01c2de9f$6eb112e0$0201a8c0@zimmer> From: "Grignon Etienne" To: References: <3E5E23B1.5D8049C5@rodos.fzk.de> Subject: Re: pgsql problem Date: Thu, 27 Feb 2003 21:33:04 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/601 X-Sequence-Number: 11999 > > > > CREATE TRIGGER OnCreateUser > > AFTER INSERT > > ON users FOR EACH ROW > > EXECUTE PROCEDURE CreateUserTrig(); > > > Have you thought of using BEFORE INSERT instead of AFTER INSERT? Well, no, but I want to do it only after the insert because I will use the primary key to insert it in an other table, so I have to be sure that it has been inserted. Could you explain to me why it doesn't work ? -- GRIGNON Etienne Epitech Promo 2005 egrignon@egrignon.com http://www.egrignon.com http://www.hans-zimmer.com