Received: from mail.grafton.lv (dns.grafton.lv [159.148.192.252]) by hub.org (8.10.1/8.10.1) with ESMTP id e5SATT115779 for ; Wed, 28 Jun 2000 06:29:29 -0400 (EDT) Received: from mortyr (unknown [159.148.192.196]) by mail.grafton.lv (Postfix) with ESMTP id 881D29380A for ; Wed, 28 Jun 2000 12:33:24 -0200 (GMT+2) From: "Emils Klotins" To: pgsql-sql@postgresql.org Date: Wed, 28 Jun 2000 12:29:24 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: trigger or something else? Message-ID: <3959EFA4.13956.28AD4E96@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200006/254 Hello, I have a table that has to have several fields with different names, but equal content. Sounds stupid, but it is because I have 2 different programs querying the same table for user information and each of them uses differently named fields. Eg. I have fields passwd and password. When passwd field changes, password must automatically change to be the same as passwd. I was wondering whether I need a trigger for that, or could I somehow manage to specify that in the "create table" stmt. If I need to do it via trigger, then I apparently need the plpgsql, right? Could you tell which configure option enables that? --enable- plpgsql? Thanks in advamce for any comments. Emils