| 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 |