Hello!
Please, help me!
Can I create working trigger on view?
The problem is:
I need a plpgsql function that execute on insert (or update,
or delete) into view and knows the *OLD* and *NEW*.
(Number of fields can be more than 16)
Something like this:
Create Sequence id;
Create Tab
"Acue" <[EMAIL PROTECTED]> writes:
> Can I create working trigger on view?
Not usefully. No tuple will ever actually be inserted into the view,
therefore the trigger will never fire.
regards, tom lane
---(end of broadcast)-
Hello!
Please, help me!
Can I create working trigger on view?
The problem is:
I need a plpgsql function that execute on insert (or update,
or delete) into view and knows the *OLD* and *NEW*.
(Number of fields can be more than 16)
Something like this:
Create Sequence id;
Create Tab
Acue,
> Can I create working trigger on view?
>
> The problem is:
> I need a plpgsql function that execute on insert (or update,
> or delete) into view and knows the *OLD* and *NEW*.
> (Number of fields can be more than 16)
No. Create a RULE instead, which can be created on a view:
http:
