Re: [GENERAL] Transaction question

On 07/11/2012 04:18 PM, Jeff Ross wrote: On 7/11/12 5:13 PM, Adrian Klaver wrote: On 07/11/2012 04:02 PM, Jeff Ross wrote: On 7/11/12 3:52 PM, Adrian Klaver wrote: Is there an index on this table? If so have you tried a REINDEX? Here's the table definition: jross@nirvana:/home/jross $ p

Re: [GENERAL] Transaction question

On 7/11/12 5:13 PM, Adrian Klaver wrote: On 07/11/2012 04:02 PM, Jeff Ross wrote: On 7/11/12 3:52 PM, Adrian Klaver wrote: Is there an index on this table? If so have you tried a REINDEX? Here's the table definition: jross@nirvana:/home/jross $ psql wykids psql (9.1.4, server 9.1.3) Type

Re: [GENERAL] Transaction question

On 07/11/2012 04:02 PM, Jeff Ross wrote: On 7/11/12 3:52 PM, Adrian Klaver wrote: Is there an index on this table? If so have you tried a REINDEX? Here's the table definition: jross@nirvana:/home/jross $ psql wykids psql (9.1.4, server 9.1.3) Type "help" for help. wykids=# \d survey_answ

Re: [GENERAL] Transaction question

On 7/11/12 4:24 PM, Marcin Mańk wrote: On Tue, Jul 10, 2012 at 10:06 PM, Jeff Ross > wrote: 2012-06-19 15:37:36.283752500 LOG: statement: update survey_response set srv_resp_submitted = now() where srv_resp_srv_id = 2 and srv_resp_pp_id = 25399 jros

Re: [GENERAL] Transaction question

On 7/11/12 3:52 PM, Adrian Klaver wrote: On 07/11/2012 02:41 PM, Jeff Ross wrote: On 7/11/12 2:07 PM, Adrian Klaver wrote: On 07/11/2012 07:01 AM, Jeff Ross wrote: On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 0

Re: [GENERAL] Transaction question

On Tue, Jul 10, 2012 at 10:06 PM, Jeff Ross wrote: > 2012-06-19 15:37:36.283752500 LOG: statement: update > survey_response set srv_resp_submitted = now() where srv_resp_srv_id = 2 > and srv_resp_pp_id = 25399 > > jross@wykids localhost# select * from survey_response where > srv_resp_submitted

Re: [GENERAL] Transaction question

On 07/11/2012 02:41 PM, Jeff Ross wrote: On 7/11/12 2:07 PM, Adrian Klaver wrote: On 07/11/2012 07:01 AM, Jeff Ross wrote: On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi a

Re: [GENERAL] Transaction question

On 7/11/12 2:07 PM, Adrian Klaver wrote: On 07/11/2012 07:01 AM, Jeff Ross wrote: On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, Thanks for any and all ideas! F

Re: [GENERAL] Transaction question

On 07/11/2012 07:01 AM, Jeff Ross wrote: On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, Thanks for any and all ideas! So would it be possible to see the actu

Re: [GENERAL] Transaction question

On 07/11/2012 07:01 AM, Jeff Ross wrote: On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, Thanks for any and all ideas! For your initial attempt everything was don

Re: [GENERAL] Transaction question

On 7/10/12 8:39 PM, Adrian Klaver wrote: On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, Thanks for any and all ideas! For your initial attempt everything was done in one session? All the inserts were d

Re: [GENERAL] Transaction question

On 07/10/2012 07:30 PM, Jeff Ross wrote: On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, Thanks for any and all ideas! For your initial attempt everything was done in one session? All the inserts were done in one session, yes. I am also confu

Re: [GENERAL] Transaction question

On 7/10/12 6:21 PM, Adrian Klaver wrote: On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, I have an anomaly on my hands that I'm at a loss to understand. We recently ran a small survey where participants were required to answer all the questions. After validation for skipped questions, mis-ra

Re: [GENERAL] Transaction question

On 07/10/2012 01:06 PM, Jeff Ross wrote: Hi all, I have an anomaly on my hands that I'm at a loss to understand. We recently ran a small survey where participants were required to answer all the questions. After validation for skipped questions, mis-ranking answers that had to be ranked and so

Re: [GENERAL] Transaction Question

On Thu, 4 Dec 2003 17:56:33 - (GMT), "John Sidney-Woollett" <[EMAIL PROTECTED]> wrote: >It would be nice if nested transactions could be (optionally) decoupled >from their enclosing transaction. While I see your point how this could be useful for certain use cases, unfortunately I don't have a

Re: [GENERAL] Transaction Question

On Thursday 04 December 2003 07:57, John Sidney-Woollett wrote: > > I'm amazed that nested transactions are still not yet supported. Postgres > is a mature product (from my understanding), and I can see loads of > messages asking about nested transaction support. Loads of messages asking for many

Re: [GENERAL] Transaction Question

Hi Scott Firstly, your name rings a bell. I'm sure you're a 4D developer - I was one too (once, but no more sadly)... You imply that it should be possible to create an embedded C function that can access the DB in its own thread, and therefore its own transaction. Is there a document that would e

Re: [GENERAL] Transaction Question

You could do something with threads on the backend, invisible to your Java middleware. I don't have enough experience to feel confident about trying to evaluate the pros and cons of (possibly) different ways of doing this. But given that you can write functions in C and load them into Postgres so t

Re: [GENERAL] Transaction Question

On Wednesday 03 December 2003 13:34, John Sidney-Woollett wrote: > Richard > > You summized correctly. The field being updated is basically a sequence > per volume. BUT the sequences cannot be shared across the volumes... Why not? Are you worried about running out of numbers, or is there some othe

Re: [GENERAL] Transaction Question

On Wednesday 03 December 2003 08:08, John Sidney-Woollett wrote: > I have to convert an java web application currently using an Oracle DB > back end to one using a Postgres backend. [snip] > Issue - nested transactions > = > [snip] > This is an issue for us because some procedures make use of a