Re: Block delete

2009-04-25 Thread Malcolm Tredinnick
On Fri, 2009-04-17 at 21:36 -0700, koranthala wrote: [...] > I understand it is done because all backends does not support it - but > can it be supported for backends which actually support it? I am using > postgresql - and now I have to do many non-optimal things to decrease > this query count.

Re: Block delete

2009-04-17 Thread koranthala
opics-db-que... > > > > > > Alex > > > > > -- > > > > > "I disapprove of what you say, but I will defend to the death your > > > right to > > > > > say it." --Voltaire > > > > > "The people'

Re: Block delete

2009-04-17 Thread koranthala
" --Voltaire > > > > "The people's good is the highest law."--Cicero > > > > Thank you Alex. > > > Sorry for troubling everyone further. But, I had a similar case of > > insert too - wherein I insert close to 2K elements at a time. > >

Re: Block delete

2009-04-17 Thread Alex Gaynor
s-db-que... > > > > > Alex > > > -- > > > "I disapprove of what you say, but I will defend to the death your > right to > > > say it." --Voltaire > > > "The people's good is the highest law."--Cicero > > > > Than

Re: Block delete

2009-04-17 Thread koranthala
e's good is the highest law."--Cicero > > Thank you Alex. Sorry for troubling everyone further. But, I had a similar case of insert too - wherein I insert close to 2K elements at a time. Currently, I do it as list = [] ... in some loop ... table = Table(values) list.append(table) ... f

Re: Block delete

2009-04-17 Thread koranthala
On Apr 17, 11:51 pm, Alex Gaynor wrote: > On Fri, Apr 17, 2009 at 2:47 PM, koranthala wrote: > > > Hi, > >    I am facing a problem which I believe should be a usual issue for > > everyone. But I cannot find a way to do it in a straightforward > > manner. > >   I have to select a list of items

Re: Block delete

2009-04-17 Thread Alex Gaynor
On Fri, Apr 17, 2009 at 2:47 PM, koranthala wrote: > > Hi, >I am facing a problem which I believe should be a usual issue for > everyone. But I cannot find a way to do it in a straightforward > manner. > I have to select a list of items from table A and delete everyone > of them. Now, there

Block delete

2009-04-17 Thread koranthala
Hi, I am facing a problem which I believe should be a usual issue for everyone. But I cannot find a way to do it in a straightforward manner. I have to select a list of items from table A and delete everyone of them. Now, there are close to 20K elements which I want to delete. So, what I do