X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 931BB47592C for ; Wed, 2 Apr 2003 21:41:46 -0500 (EST) Received: from hub.org (hub.org [64.117.224.146]) by postgresql.org (Postfix) with ESMTP id 060F1474E44 for ; Wed, 2 Apr 2003 21:41:46 -0500 (EST) Received: from hub.org (hub.org [64.117.224.146]) by hub.org (Postfix) with ESMTP id C05741038DCE for ; Wed, 2 Apr 2003 22:41:44 -0400 (AST) Date: Wed, 2 Apr 2003 22:41:42 -0400 (AST) From: "Marc G. Fournier" To: pgsql-sql@postgresql.org Subject: simple trigger question ... Message-ID: <20030402223933.M71125@hub.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-6.4 required=5.0 tests=BAYES_00 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/24 X-Sequence-Number: 12725 I want to create a trigger on a table that for every insert, in performs a nextval on a sequence ... Something like: CREATE TRIGGER on_company_company_id_seq AFTER INSERT ON company FOR EACH ROW EXECUTE PROCEDURE nextval('company_company_id_seq'); I'm embaressingly new at triggers ... is this possible?