Re: Good way to insert/update when you're not sure of

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Good way to insert/update when you're not sure of
Дата
Msg-id Pine.LNX.4.33.0309261002100.21251-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Good way to insert/update when you're not sure of duplicates?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
On Fri, 26 Sep 2003, Shridhar Daithankar wrote:

> On Friday 26 September 2003 21:08, Dennis Gearon wrote:
> > corruption of the databases, if I'm correct.
>
> > Shridhar Daithankar wrote:
> > >On Friday 26 September 2003 20:48, Dennis Gearon wrote:
> > >>I didn't think mulitple backends worked.
> > >
> > >Why? Why can't you insert using multiple backends? I mean is there a
> > > problem?
>
> How does database gets corrupted? If you have 20 backend inserting their own
> chunk of data in separate transactions, where does database corruption comes
> in picture?
>
> That's the whole idea of transactions.

I think Dennis is confusing multiple backends (legal and safe, each
connection gets its own backend) with multiple postmasters (not legal,
very unsafe, causes corruption, etc...)


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

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: Good way to insert/update when you're not sure of duplicates?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: About GPL and proprietary software