Re: Delay INSERT - Mailing list pgsql-general

From Tom Lane
Subject Re: Delay INSERT
Date
Msg-id 8115.1111599180@sss.pgh.pa.us
Whole thread Raw
In response to Re: Delay INSERT  (Dawid Kuroczko <qnex42@gmail.com>)
Responses Re: Delay INSERT
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: backend process
Next
From: Tom Lane
Date:
Subject: Re: multi line text data/query ?bug?