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