Re: Partitioning and ORM tools

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Partitioning and ORM tools
Дата
Msg-id CANu8FiyO_t7wPfVRn3_m2fvp7Y4vWxgmpXWG7tudHksDrMXbLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partitioning and ORM tools  (CS DBA <cs_dba@consistentstate.com>)
Список pgsql-general


On Tue, Mar 22, 2016 at 5:20 PM, CS DBA <cs_dba@consistentstate.com> wrote:


On 03/22/2016 03:18 PM, Rob Sargent wrote:


On 03/22/2016 03:00 PM, Joshua D. Drake wrote:
On 03/22/2016 01:50 PM, CS DBA wrote:

Understood, was just wondering if there is a way to cause the child
table insert results to be returned to the ORM/Application instead of
the master/base table insert

Insert into the child table directly based on the partition rules.

JD


I would think the ORM (as yet undefined) would want to think in terms of the parent table and not know about the physical schema details.
Can  the client not be written to check only for errors vs checking for non-zero inserts?



That was our first suggestion, they don;t want to make any app changes





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I highly suspect this is a problem with trigger function design, constraint conflict or a bad insert statement, but since no details have been provided, it cannot be resolved.
IOW, all they said was "It don't work", but they have not provided proof.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: CS DBA
Дата:
Сообщение: Re: Partitioning and ORM tools
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Partitioning and ORM tools