Re: [GENERAL] Inserting from multiple processes?

2015-06-28 Thread Dave Johansen
On Sat, Jun 27, 2015 at 11:00 AM, Francisco Olarte wrote: > Hi Dave: > > On Fri, Jun 26, 2015 at 2:59 AM, Dave Johansen > wrote: > > > It appears that calling "SELECT insert_test_no_dup('2015-01-01', 1, 1)" > > cause the XID to increment? I'm

Re: [GENERAL] Inserting from multiple processes?

2015-06-25 Thread Dave Johansen
On Tue, Jun 9, 2015 at 8:38 AM, Dave Johansen wrote: > On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen > For the sake of documentation, here's the function that I used to > accomplish this: > CREATE FUNCTION insert_test_no_dup(tutc_ TIMESTAMP WITHOUT TIME ZONE, id_ > INT

Re: [GENERAL] Inserting from multiple processes?

2015-06-09 Thread Dave Johansen
On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen wrote: > I'm using Postgres 8.4 on RHEL 6 and I need to support inserting data into > a table from multiple processes with there occasionally being duplicates > from the different processes. Here's a simple example table: > C

[GENERAL] Inserting from multiple processes?

2015-06-08 Thread Dave Johansen
I'm using Postgres 8.4 on RHEL 6 and I need to support inserting data into a table from multiple processes with there occasionally being duplicates from the different processes. Here's a simple example table: CREATE TABLE test (tutc TIMESTAMP WITHOUT TIME ZONE, id INTEGER, value INTEGER, PRIMARY KE