Statement Triggers. Ideas & help.

From: "F J Cuberos" <fjcuberos(at)infomail(dot)lacaixa(dot)es>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Statement Triggers. Ideas & help.
Date: 1999-08-15 14:28:03
Message-ID: 001101bee72a$63240420$67cf35c3@default
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I´m trying to implement Statement Triggers in postgreSQL. The basic idea is
check (in ExcutePlan) if there are statement before call first time to
ExecAppend, ExecDelete or ExecUpdate (or after the last call in case of
after statement).

But if I exec "Insert into tbtest values (22,'cadena');" then ExecutePlan is
call two times, and ExecX too. Why?
The execution trace is:
Entering ExecutePlan
Calling ExecAppend
Entering ExecAppend
Entering ExecutePlan
Calling ExecAppend
Entering ExecAppend

Other Question: SQL3 says
" The execution of triggered actionsdepends on the cursosr mode of the
current SQ-transaction. If the cursor mode is set to cascade off, then the
execution of the <triggered SQL statement>s is effectively deferred until
enacted implicitly by execution of a <commit statement> or a <close
statement>. Otherwise, the <triggered SQl statement>s are effectively
executed ..."

How apply this to postgre?

Thanks everybody.

F.J.Cuberos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message F J Cuberos 1999-08-15 22:41:51 RE: [HACKERS] Statement Triggers. Ideas & help.
Previous Message Bruce Momjian 1999-08-15 14:12:52 psql return code for NOTICE