Re: Good way to insert/update when you're not sure of duplicates? - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Good way to insert/update when you're not sure of duplicates?
Date
Msg-id 3F74651C.9080103@fireserve.net
Whole thread Raw
In response to Re: Good way to insert/update when you're not sure of duplicates?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Well, I may have my merms tixed up!

There is ONE component of Postgres that can only be accessing the
database by itself. Maybe it's not the 'backend', it's probably the
postmaster. Are they the same? I don't know.

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.
>
> Shridhar
>
>
>
>


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Good way to insert/update when you're not sure of duplicates?
Next
From: "scott.marlowe"
Date:
Subject: Re: Good way to insert/update when you're not sure of