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 по дате отправления: