Re: Postgres 9.6 - ltree extension - (re)build a tree on a table

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Postgres 9.6 - ltree extension - (re)build a tree on a table
Дата
Msg-id CAKFQuwYggqUSW_yTui5U+1PzEK1+UA7zcj+4MepWV95tKD-NCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres 9.6 - ltree extension - (re)build a tree on a table  (Luca <lordluke80@gmail.com>)
Список pgsql-sql
Дерево обсуждения
On Tue, Apr 17, 2018 at 3:11 AM, Luca <lordluke80@gmail.com> wrote:
Since this table should be updated after a data import, so after a massive upsert, ideally I would i'd like to have a function 
called after that is completed, in order to (re)build the 'path' column for each record, which means rebuild the tree.

​Have you considered/tried an "FOR EACH STATEMENT" trigger instead of "FOR EACH ROW"​?

The transition tables feature introduced in v10 probably will be of significant help here as well - though I haven't any practical experience with it personally.

https://www.postgresql.org/docs/current/static/sql-createtrigger.html

David J.

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

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: Postgres 9.6 - ltree extension - (re)build a tree on a table
Следующее
От: Gary Stainburn
Дата:
Сообщение: summary view design / performance