Re: [HACKERS] Transaction question

2007-11-23 Thread Kevin Grittner
>>> On Fri, Nov 23, 2007 at 5:31 AM, in message <[EMAIL PROTECTED]>, Dragan Zubac <[EMAIL PROTECTED]> wrote: > > Didn't know where to submit question regarding design&performance. This page is the place to figure that out: http://www.postgresql.org/community/lists/ For the questions you h

[HACKERS] Transaction question

2007-11-23 Thread Dragan Zubac
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: [HACKERS] Transaction question

2004-03-30 Thread kkim3
Thank you. At the first time, it works well. But if I try to do same command again, it still give me a server crash error. > On Tue, Mar 30, 2004 at 12:58:31PM -0500, [EMAIL PROTECTED] wrote: > >> I'm trying to insert new row in a system catalog table and then I'd like >> to retrieve this value in

Re: [HACKERS] Transaction question

2004-03-30 Thread Alvaro Herrera
On Tue, Mar 30, 2004 at 12:58:31PM -0500, [EMAIL PROTECTED] wrote: > I'm trying to insert new row in a system catalog table and then I'd like > to retrieve this value in one command internally. I started new > transaction for insertion operation and commited that transaction. And > insert operatio

[HACKERS] Transaction question

2004-03-30 Thread kkim3
Hello, I'm trying to insert new row in a system catalog table and then I'd like to retrieve this value in one command internally. I started new transaction for insertion operation and commited that transaction. And insert operation works well, but I give me server crash error. Could you let me kno