Re: When inserting from a SELECT with an ORDER BY, are the inserts (and associated triggers) applied in order?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jim Fulton <jim(at)jimfulton(dot)info>
Cc: "pgsql-gener(dot)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: When inserting from a SELECT with an ORDER BY, are the inserts (and associated triggers) applied in order?
Date: 2017-06-26 21:43:42
Message-ID: 16028.1498513422@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jim Fulton <jim(at)jimfulton(dot)info> writes:
> When inserting from a SELECT with an ORDER BY, are the inserts (and
> associated triggers) applied in order?

Yeah, I'd expect so. I'm not sure we'd promise that that will always
remain true, but I can't think why it would be violated at the moment.

> It looks like inserts aren't applied in order, and I'm wondering if this is
> something I should expect.

Hard to comment on that without seeing your test case.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-06-26 21:48:41 Re: ERROR: query returned no rows
Previous Message Paul A Jungwirth 2017-06-26 20:10:46 Re: ERROR: query returned no rows