> > Triggers:
> >     my_little^trigger BEFORE UPDATE ON test FOR EACH STATEMENT EXECUTE
PROCEDURE foofun()
>
> Bizarre.  It looks fine here.  What platform are you on?  Anyone else
> see this?

I actually had this while I was developing the feature.  I had thought I had
fixed it.  It's basically total weirdness in the behaviour of
appendStringInfo function IIRC.  Basically, I _think_ it was caused by
having two %s's in this:

       appendStringInfo(&buf, "CREATE %sTRIGGER %s ",
                                         trigrec->tgisconstraint ?
"CONSTRAINT " : "",
                                         quote_identifier(tgname));

I managed to get rid of the bug on my development machine, but it's
obviously cropped up again :(

Chris


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to