Skip site navigation (1) Skip section navigation (2)

Re: Transaction question

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: kkim3(at)ncsu(dot)edu
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transaction question
Date: 2004-03-30 19:46:20
Message-ID: 20040330194620.GA10295@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Mar 30, 2004 at 12:58:31PM -0500, kkim3(at)ncsu(dot)edu 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 operation works well, but I give me server crash error. Could you
> let me know how can I handle transactions for insertion and selection
> sequentially in one command?

I think rather than starting and committing a new transaction, what you
want to do is CommandCounterIncrement() after inserting without messing
the transaction mechanism.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The eagle never lost so much time, as
when he submitted to learn of the crow." (William Blake)

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2004-03-30 21:19:42
Subject: Update on PITR
Previous:From: Josh BerkusDate: 2004-03-30 19:34:15
Subject: Inconsistent behavior on Array & Is Null?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group