Re: [GENERAL] Parallel Insert and Delete operation

2012-11-07 Thread Yelai, Ramkumar IN BLR STS
Ramkumar Yelai wrote: [is worried that a database might become inconsistent if conflicting INSERTs and DELETEs occur] > @Albe - I got you first point. The second point is little skeptical because postgres could have been > avoided this lock by using MVCC. Please correct me if I am wrong? Which

Re: [GENERAL] Parallel Insert and Delete operation

2012-11-05 Thread Albe Laurenz
Ramkumar Yelai wrote: [is worried that a database might become inconsistent if conflicting INSERTs and DELETEs occur] > @Albe - I got you first point. The second point is little skeptical because postgres could have been > avoided this lock by using MVCC. Please correct me if I am wrong? Which l

Re: [GENERAL] Parallel Insert and Delete operation

2012-11-05 Thread Yelai, Ramkumar IN BLR STS
te: > Sent: Wednesday, October 31, 2012 12:40 PM > To: pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org> > Subject: [GENERAL] Parallel Insert and Delete operation > > Hi All, > > Please clarify me the following example. > > I have 2 tables >

Re: [GENERAL] Parallel Insert and Delete operation

2012-10-31 Thread Moshe Jacobson
12:40 PM > > To: pgsql-general@postgresql.org > > Subject: [GENERAL] Parallel Insert and Delete operation > > > > Hi All, > > > > Please clarify me the following example. > > > > I have 2 tables > > > > Table1 - ( it has one primary key and

Re: [GENERAL] Parallel Insert and Delete operation

2012-10-31 Thread Albe Laurenz
Yelai, Ramkumar IN BLR STS worte: > Sent: Wednesday, October 31, 2012 12:40 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Parallel Insert and Delete operation > > Hi All, > > Please clarify me the following example. > > I have 2 tables > > Table

[GENERAL] Parallel Insert and Delete operation

2012-10-31 Thread Yelai, Ramkumar IN BLR STS
Hi All, Please clarify me the following example. I have 2 tables Table1 - ( it has one primary key and few columns ) Table2 - ( it has one primary key and few columns. It has one foreign key, which refers table1 primary key ). I have 2 operations, which are written in pl/pgsql procedure.