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 [EMAIL PROTECTED] ========================================================================== "The earth is but one country, and mankind its citizens." -- Baha'u'llah ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
