Re: autocommit vs TRUNCATE et al
| От | Tom Lane |
|---|---|
| Тема | Re: autocommit vs TRUNCATE et al |
| Дата | |
| Msg-id | 4066.1035238715@sss.pgh.pa.us обсуждение |
| Ответ на | Re: autocommit vs TRUNCATE et al (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: autocommit vs TRUNCATE et al
|
| Список | pgsql-hackers |
>>> ... I think we
>>> should just do an automatic COMMIT if it is the first statement of a
>>> transaction, and if not, throw the same error we used to throw. We are
>>> performing autocommit for SET at the start of a transaction now anyway,
>>> so it isn't totally strange to do it for TRUNCATE, etc. too.
>>
>> We can go with the auto-COMMIT idea for statements that are invoked at
>> the outer interactive level,
What I just committed uses your idea of auto-committing TRUNCATE et al,
but now that I review the thread I think that everyone else thought that
that was a dangerous idea. How do you feel about simply throwing an error
in autocommit-off mode, instead? (At least it's a localized change now)
regards, tom lane
В списке pgsql-hackers по дате отправления: