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

From: Jim Fulton <jim(at)jimfulton(dot)info>
To: "pgsql-gener(dot)" <pgsql-general(at)postgresql(dot)org>
Subject: When inserting from a SELECT with an ORDER BY, are the inserts (and associated triggers) applied in order?
Date: 2017-06-26 20:06:43
Message-ID: CAPDm-FgA99dx6Ytc8zMUMozDpBHyC_carLzYLbS4xwcp96h3uQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Jim

--
Jim Fulton
http://jimfulton.info

Responses

Browse pgsql-general by date

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