Re: two buglets: createlang and pg_get_triggerdef

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: two buglets: createlang and pg_get_triggerdef
Дата
Msg-id 035801c357c9$37bd6d30$2800a8c0@mars
обсуждение исходный текст
Ответ на two buglets: createlang and pg_get_triggerdef  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Ответы Re: two buglets: createlang and pg_get_triggerdef  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: two buglets: createlang and pg_get_triggerdef
Следующее
От: Tom Lane
Дата:
Сообщение: Re: two buglets: createlang and pg_get_triggerdef