Re: Conditional INSERT: if not exists

Поиск
Список
Период
Сортировка
Искать
От
Don Morrison
Тема
Re: Conditional INSERT: if not exists
Дата
Msg-id
aee6519f0608231445h4e623a2xda2ecf1f48a6cfe6@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists "Phillip Smith" <phillips@weatherbeeta.com.au>
Re: Conditional INSERT: if not exists Sean Davis <sdavis2@mail.nih.gov>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists Franck Routier <franck.routier@axege.com>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists Bruno Wolff III <bruno@wolff.to>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists Sean Davis <sdavis2@mail.nih.gov>
Re: Conditional INSERT: if not exists "Don Morrison" <donmorrison@gmail.com>
Re: Conditional INSERT: if not exists Stuart Bishop <stuart@stuartbishop.net>
> isn't a problem.  If you need to do this in a transaction, you can
> simply set savepoints and roll back to the savepoint if an insert fails
> (and you expected that it could).

Unfortunately, for some reason it does a rollback of the entire outer
transaction too, not just the nested one. :(  Anybody know why?

If I use stored procedures will it be easier?
В списке pgsql-novice по дате отправления
От: Don Morrison
Дата:
От: Don Morrison
Дата:
FAQ