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

2017-06-26 Thread Jim Fulton
On Mon, Jun 26, 2017 at 5:43 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Jim Fulton <j...@jimfulton.info> writes: > > When inserting from a SELECT with an ORDER BY, are the inserts (and > > associated triggers) applied in order? > > Yeah, I'd expe

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

2017-06-26 Thread Jim Fulton
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

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
On Thu, Jun 15, 2017 at 1:56 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Jim Fulton <j...@jimfulton.info> writes: > > I have an object database that's mirrored to a table with data in a JSONB > > column. Data are organized into "communities". Community ids

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
On Thu, Jun 15, 2017 at 1:44 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 06/15/2017 10:23 AM, Jim Fulton wrote: > ... > I do not pretend to fully understand what the the triggers/functions are > really doing, but I did notice this: > > cr

[GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
r database integrity? - Any suggestions on how to debug this? Jim -- Jim Fulton http://jimfulton.info