From: | Camm Maguire <camm(at)enhanced(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | create trigger on view |
Date: | 2002-12-17 19:41:54 |
Message-ID: | 54r8cgqvp9.fsf@intech19.enhanced.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings! Somewhere between 7.1 and 7.2, creating triggers on insert
to a view has been disallowed. The docs still report it as a
possibility -- see rules vs. triggers. Worse, we have a postgres
database relying on this feature for several years now. What can I
do? I suppose I could use a rule, but all the insert rule examples I
can find in the docs have simple sql do instead clauses, whereas my
trigger called a rather involved plsql function.
Advice most appreciated.
Take care,
--
Camm Maguire camm(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah
From | Date | Subject | |
---|---|---|---|
Next Message | Tariq Muhammad | 2002-12-17 20:10:39 | Re: ERROR: fmgr_info: function 24809: cache lookup failed |
Previous Message | Lamar Owen | 2002-12-17 19:28:02 | Re: RPMS for Redhat 7.3 ?? |