Re: Trigger position
| От | Euler Taveira |
|---|---|
| Тема | Re: Trigger position |
| Дата | |
| Msg-id | bf7292b9-7cf3-43f8-8676-df2a1f47d716@www.fastmail.com обсуждение исходный текст |
| Ответ на | Re: Trigger position (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
| Ответы |
Re: Trigger position
Re: Trigger position |
| Список | pgsql-hackers |
On Wed, Sep 15, 2021, at 10:51 AM, Alvaro Herrera wrote:
In a computer system, alphabet letters are just a different way topresent numbers, so you just choose ASCII letters that match what youwant. You can use "AA_first_trigger", "BB_second_trigger","AB_nope_this_is_second" and you'll be fine; you can do"AAB_oops_really_second" afterwards, and so on. The integer numberingsystem doesn't seem very useful/flexible when seen in this light.
... or renumber all trigger positions in a single transaction. I agree that
letters are more flexible than numbers but some users are number-oriented.
I'm afraid an extra mechanism to determine the order to fire triggers will
confuse programmers if someone decides to use both. Besides that, we have to
expend a few cycles to determine the exact trigger execution order.
В списке pgsql-hackers по дате отправления: