Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-06-11 Thread Amit Kapila
On Tuesday, June 11, 2013 12:15 AM Tom Lane wrote: > [ got around to looking at this thread finally ] > > Amit Kapila writes: > > What happens when you change ON DELETE rule of the view that really > deletes > > elements is that command type after applying rule remains same which > means > > Dele

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-06-10 Thread Tom Lane
[ got around to looking at this thread finally ] Amit Kapila writes: > What happens when you change ON DELETE rule of the view that really deletes > elements is that command type after applying rule remains same which means > Delete, so it can set the Tag. The point here is that in extended-quer

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 6:50 PM Brice André wrote: > Hello Amit, > > Thanks for your answer. > > The reason why it does not work is still not really clear for me .What > I find very strange is that, if you perform exactly same request, with > exactly same C++ code, but that you change the databa

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 1:54 PM Brice André wrote: > On Tuesday, May 28, 2013 1:28 PM Brice André wrote: > > I shall look into it today in later half of the day. > > Dear Amit, > > > > Thanks for your answer. > > > > I performed the same test as you and I get the same result (on my > > linux serv

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 1:28 PM Brice André wrote: I shall look into it today in later half of the day. > Dear Amit, > > Thanks for your answer. > > I performed the same test as you and I get the same result (on my > linux server, debian, postgresql 8.4). > > Maybe the problem is related to li

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Guillaume Lelarge
On Tue, 2013-05-28 at 12:41 +0530, Amit Kapila wrote: > On Tuesday, May 28, 2013 12:39 AM Brice André wrote: > > Dear all, > > > > I found what I really think is a bug in the postgresql 8.4. > > > > I have an sql database structure in which a real table has a column > > that is used to mark the e

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 12:39 AM Brice André wrote: > Dear all, > > I found what I really think is a bug in the postgresql 8.4. > > I have an sql database structure in which a real table has a column > that is used to mark the entries as deleted without really deleting > them. Then, I have a vie