Re: strange commit behavior

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: strange commit behavior
Дата
Msg-id 2f4958ff0811180537r53c3b9bdga5fa581a8a10b8a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: strange commit behavior  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general


On Tue, Nov 18, 2008 at 1:25 PM, Craig Ringer <craig@postnewspapers.com.au> wrote:


You can use savepoints (see the manual) to recover from errors, though
they have some issues if you use hundreds of thousands of savepoints in
a single transaction. It's much better to check the data on INSERT to
make sure it's OK. You can do this with an INSERT ... SELECT (and check
the rowcount), with a PL/PgSQL function that returns a result value, do
it client-side, etc.

can you post an example ?
would that also resolve problem with 'rowcount' left unset, if trigger or rule is used on table ?
 

--
GJ

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Urgent - Grant
Следующее
От: Gustavo Rosso
Дата:
Сообщение: Re: Urgent - Grant