X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A3E218BA293 for ; Wed, 16 Feb 2005 13:44:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45366-02 for ; Wed, 16 Feb 2005 13:44:45 +0000 (GMT) Received: from benhur.intern.intend.de (intern.intend-online.de [80.69.207.98]) by svr1.postgresql.org (Postfix) with ESMTP id B41CA8B9CA4 for ; Wed, 16 Feb 2005 13:44:44 +0000 (GMT) Received: from thuja ([192.168.100.173]) by benhur.intern.intend.de (8.12.8p1/8.12.6/Benhur 8.12.6) with SMTP id j1GDhtM2030708 for ; Wed, 16 Feb 2005 14:43:56 +0100 From: "Eugen Gass" To: Subject: Trigger Date: Wed, 16 Feb 2005 14:43:54 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/144 X-Sequence-Number: 16312 Hi, I'm trying to create a trigger on PostgreSQL it should be like an oracle(sql) sample code: create or replace trigger frei_polygon_sync after INSERT on frei_polygon Referencing NEW as newROW for each row Begin :newRow.objektid := :newRow.gid; : end; Can sombody help me to do the same on Postrgres Best Regards EG