Re: [GENERAL] On duplicate ignore

2012-01-20 Thread Florian Weimer
* Lincoln Yeoh: > Is there a simple way to get postgresql to retry a transaction, or > does the application have to actually reissue all the necessary > statements again? The application has to re-run the transaction, which might result in the execution of different statements. In the INSERT-or-

Re: [GENERAL] On duplicate ignore

2012-01-20 Thread Lincoln Yeoh
At 04:27 PM 1/20/2012, Florian Weimer wrote: * Lincoln Yeoh: >>If you use serializable transactions in PostgreSQL 9.1, you can >>implement such constraints in the application without additional >>locking. However, with concurrent writes and without an index, the rate >>of detected serialization

Re: [GENERAL] On duplicate ignore

2012-01-20 Thread Florian Weimer
* Lincoln Yeoh: >>If you use serializable transactions in PostgreSQL 9.1, you can >>implement such constraints in the application without additional >>locking. However, with concurrent writes and without an index, the rate >>of detected serialization violations and resulting transactions aborts >

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Lincoln Yeoh
At 10:54 PM 1/19/2012, Florian Weimer wrote: * Gnanakumar: >> Just create a unique index on EMAIL column and handle error if it comes > > Thanks for your suggestion. Of course, I do understand that this could be > enforced/imposed at the database-level at any time. But I'm trying to find > out

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Florian Weimer
* Scott Marlowe: > On Thu, Jan 19, 2012 at 7:54 AM, Florian Weimer wrote: >> * Gnanakumar: >> Just create a unique index on EMAIL column and handle error if it comes >>> >>> Thanks for your suggestion.  Of course, I do understand that this could be >>> enforced/imposed at the database-level

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Scott Marlowe
On Thu, Jan 19, 2012 at 9:49 AM, Scott Marlowe wrote: > On Thu, Jan 19, 2012 at 7:54 AM, Florian Weimer wrote: >> * Gnanakumar: >> Just create a unique index on EMAIL column and handle error if it comes >>> >>> Thanks for your suggestion.  Of course, I do understand that this could be >>> en

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Scott Marlowe
On Thu, Jan 19, 2012 at 7:54 AM, Florian Weimer wrote: > * Gnanakumar: > >>> Just create a unique index on EMAIL column and handle error if it comes >> >> Thanks for your suggestion.  Of course, I do understand that this could be >> enforced/imposed at the database-level at any time.  But I'm tryi

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Florian Weimer
* Gnanakumar: >> Just create a unique index on EMAIL column and handle error if it comes > > Thanks for your suggestion. Of course, I do understand that this could be > enforced/imposed at the database-level at any time. But I'm trying to find > out whether this could be solved at the applicatio

Re: [GENERAL] On duplicate ignore

2012-01-18 Thread Atul Goel
@postgresql.org Subject: RE: [GENERAL] On duplicate ignore > Just create a unique index on EMAIL column and handle error if it > comes Thanks for your suggestion. Of course, I do understand that this could be enforced/imposed at the database-level at any time. But I'm trying to find out w

Re: [GENERAL] On duplicate ignore

2012-01-18 Thread Dmitriy Igrishin
Hey Gnanakumar, 2012/1/18 Gnanakumar > > Just create a unique index on EMAIL column and handle error if it comes > > Thanks for your suggestion. Of course, I do understand that this could be > enforced/imposed at the database-level at any time. But I'm trying to find > out whether this could b

Re: [GENERAL] On duplicate ignore

2012-01-18 Thread Gnanakumar
> Just create a unique index on EMAIL column and handle error if it comes Thanks for your suggestion. Of course, I do understand that this could be enforced/imposed at the database-level at any time. But I'm trying to find out whether this could be solved at the application layer itself. Any th

Re: [GENERAL] On duplicate ignore

2012-01-18 Thread Atul Goel
Just create a unique index on EMAIL column and handle error if it comes Thanks, Atul Goel -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gnanakumar Sent: 18 January 2012 11:04 To: pgsql-general@postgresql.org Subject: