| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Jakub Ouhrabka <jouh8664(at)ss1000(dot)ms(dot)mff(dot)cuni(dot)cz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: triggers and plpgsql |
| Date: | 2001-08-03 14:50:53 |
| Message-ID: | Pine.BSF.4.21.0108030739250.15948-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 3 Aug 2001, Jakub Ouhrabka wrote:
> hi,
> i'm getting strange results when executing the code below. i would expect
> that li_count in function foo and the select after calling this function
> should return same values. can anyone explain me why i'm getting these
> results, please?
AFAICS the after triggers are going to be delayed until the outer
statement is completing. That would means when the select
foo() is finishing up, the after triggers run, so between the delete and
select in the function, the trigger hasn't been called yet.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-03 14:51:22 | Re: triggers and plpgsql |
| Previous Message | Fran Fabrizio | 2001-08-03 14:22:19 | Re: encrypting a password field in the database |