> > 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