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 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)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
