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

[GENERAL] Transaction question

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 on, I did all of the inserts to the su

[GENERAL] Transaction question

Hello all Didn't know where to submit question regarding design&performance. Here's the situation. Basically process will take one message at a time,send it and the will send another one,each process knows which message to take from the table based on provider value. First situation: table

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

[GENERAL] Transaction Question

I have to convert an java web application currently using an Oracle DB back end to one using a Postgres backend. In Oracle much of the application logic is abstracted away from the java middleware layer using stored procedures within the Oracle database. There are certain features in Oracle that a