| From: | "Emils Klotins" <emils(at)dot(dot)lv> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | trigger or something else? | 
| Date: | 2000-06-28 10:29:24 | 
| Message-ID: | 3959EFA4.13956.28AD4E96@localhost | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2000-06-28 10:52:40 | Re: trigger or something else? | 
| Previous Message | David Craig | 2000-06-28 10:19:14 | extracting a table description |