Re: Transaction question

Поиск
Список
Период
Сортировка
От kkim3@ncsu.edu
Тема Re: Transaction question
Дата
Msg-id 4182.152.7.234.33.1080684929.squirrel@webmail.ncsu.edu
обсуждение исходный текст
Ответ на Re: Transaction question  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
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, kkim3@ncsu.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)
>



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Update on PITR
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cvs HEAD regression