On Thu, 11 Aug 2005, Surabhi Ahuja wrote:
> the stored procedure (just the pseudo code)
> table x has a primary key k
> insert(integer)
> {
> select from table if k = $1
> if not found
> insert into x ($1);
> else
>insert into some_other_table($1);
> end if
>
# [EMAIL PROTECTED] / 2005-08-11 16:04:00 +0530:
> void *connect(void* threadid)
> {
> char command[100];
> int *id_ptr, taskid;
> id_ptr = (int *) threadid;
> taskid = *id_ptr;
> if(taskid == 0)
> strcpy(command, "select insert (1)");
> else if(taskid == 1)
>
Surabhi Ahuja wrote:
void *connect(void* threadid)
{
char command[100];
int *id_ptr, taskid;
id_ptr = (int *) threadid;
taskid = *id_ptr;
if(taskid == 0)
strcpy(command, "select insert (1)");
else if(taskid == 1)
strcpy(command, "select insert (1)");
...
void
*connect(void* threadid){ char
command[100]; int *id_ptr, taskid;
id_ptr = (int *) threadid; taskid = *id_ptr;
if(taskid ==
0) strcpy(command, "select insert
(1)"); else if(taskid ==
1) strcpy(command, "select insert
(1)"); else if(taskid ==
2)
On Thu, Aug 11, 2005 at 03:17:53PM +0530, Surabhi Ahuja wrote:
> This is in continuation of my previous mail:
> each thread is using a different pgconn.
> Please tell, in case I should provide more info in regard to this scenario?
Yes. I've no idea what your problem might be, and I'm probably
This is in
continuation of my previous mail:
each thread is using a different pgconn.
thanks again
Surabhi Ahuja
Dear All,
I am stuck in the following scenario:
In a dual processor machine, I am running 5
threads.
each of the threads is calling a particular stored
procedure to insert a ro
Dear All,
I am stuck in the following scenario:
In a dual processor machine, I am running 5
threads.
each of the threads is calling a particular stored
procedure to insert a row in the table.
the insertion takes place in a transaction and i
have set the transaction level to serializable.
