On Tue, Jun 10, 2008 at 7:14 AM, Shavonne Marietta Wijesinghe <[EMAIL PROTECTED]> wrote: > I managed to make the connection work. I tried inserting records from 2 > computers. It works fine untill 2 computers insert a nextwall one after > another. > > Here is a small example of what i see in my DB > > ++++++|+++++++++++++++++|++++++++++ > N ° | Session | Number > ++++++|+++++++++++++++++ |++++++++++ > 1 | DB last record | 269 > 2 | PC A (nextval ) | 270 > 3 | PC A (nextval ) | 271 > 4 | PC A (currval ) | 271 > 5 | PC A (nextval ) | 272 > 6 | PC A (nextval ) | 273 > 7 | PC B (nextval ) | 274 > 8 | PC A (currval ) | 274 > 9 | PC B (nextval ) | 275 > 10 | PC A (nextval ) | 276
Are you using connection pooling? Could it be that session PC A on the client side is switching connections between 6 and 8? What to you get from pg_backend_pid() in the two instances of time 6 and 8? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
