Re: Delay INSERT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delay INSERT
Дата
Msg-id 8115.1111599180@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Delay INSERT  (Dawid Kuroczko <qnex42@gmail.com>)
Ответы Re: Delay INSERT  (Dawid Kuroczko <qnex42@gmail.com>)
Список pgsql-general
Dawid Kuroczko <qnex42@gmail.com> writes:
> PostgreSQL doesn't have such issues with blocking, so only difference
> between INSERT and INSERT DELAYED from PostgreSQL's standpoint
> would be waiting and not for the result...

With the right client-side code you can transmit multiple queries before
receiving the result from the first one.  I don't think libpq in its
current incarnation really supports this, but in principle it's doable.

The interesting questions have to do with error handling: if the
"delayed" insert fails, what happens and what is the impact on
subsequent queries?  I have no idea how MySQL defines that.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: backend process
Следующее
От: Tom Lane
Дата:
Сообщение: Re: multi line text data/query ?bug?