INSERT to partitioned table doesn't return row count

Поиск
Список
Период
Сортировка
От Kris Deugau
Тема INSERT to partitioned table doesn't return row count
Дата
Msg-id 547F6253.60200@vianet.ca
обсуждение исходный текст
Ответы Re: INSERT to partitioned table doesn't return row count  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Is it possible to return the number of rows inserted to a partitioned
table set up as per the examples on
http://www.postgresql.org/docs/9.1/interactive/ddl-partitioning.html, in
the same way as if you inserted directly into a target table?

I can sort of see why it returns 0, because 0 rows are actually inserted
in the parent table, but I'd prefer not to have to make all the code
around this use case partition-aware;  most of it isn't mine.

I tried modifying the last RETURN line in the trigger function but
couldn't find anything that was even valid syntax.

-kgd


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

Предыдущее
От: mongoose
Дата:
Сообщение: Re: Merge rows based on Levenshtein distance
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: Merge rows based on Levenshtein distance