Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-24 Thread Kevin Grittner
Jeevan Chalke wrote: > On Wed, Apr 24, 2013 at 3:04 AM, Kevin Grittner wrote: >> Any objections to the attached to fix this issue? > Nope. Fine with me. Pushed.  Thanks for the report! -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-24 Thread Jeevan Chalke
On Wed, Apr 24, 2013 at 3:04 AM, Kevin Grittner wrote: > Jeevan Chalke wrote: > > On Mon, Apr 22, 2013 at 6:41 PM, Andres Freund > wrote: > >> On 2013-04-22 18:35:04 +0530, Jeevan Chalke wrote: > > >>> I have observed that following sequence is causing server crash. > >>> > >>> CREATE MATERIALI

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Michael Paquier
On Tue, Apr 23, 2013 at 11:05 PM, Andres Freund wrote: > On 2013-04-23 19:33:24 +0530, Jeevan Chalke wrote: > > On Tue, Apr 23, 2013 at 7:01 PM, Merlin Moncure > wrote: > > > > > On Tue, Apr 23, 2013 at 7:18 AM, Jeevan Chalke > > > wrote: > > > > Hi Tom, > > > > > > > > Since we are close to rel

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Kevin Grittner
Jeevan Chalke wrote: > On Mon, Apr 22, 2013 at 6:41 PM, Andres Freund wrote: >> On 2013-04-22 18:35:04 +0530, Jeevan Chalke wrote: >>> I have observed that following sequence is causing server crash. >>> >>> CREATE MATERIALIZED VIEW temp_class_mv AS >>>   SELECT * FROM pg_class >>>   WITH NO DA

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Andres Freund
On 2013-04-23 19:33:24 +0530, Jeevan Chalke wrote: > On Tue, Apr 23, 2013 at 7:01 PM, Merlin Moncure wrote: > > > On Tue, Apr 23, 2013 at 7:18 AM, Jeevan Chalke > > wrote: > > > Hi Tom, > > > > > > Since we are close to release, we should not have crashes like this. > > > > huh? we are not even

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Jeevan Chalke
On Tue, Apr 23, 2013 at 7:01 PM, Merlin Moncure wrote: > On Tue, Apr 23, 2013 at 7:18 AM, Jeevan Chalke > wrote: > > Hi Tom, > > > > Since we are close to release, we should not have crashes like this. > > huh? we are not even in beta yet > I mean, beta release. BTW, as per Bruce's mail "w

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Merlin Moncure
On Tue, Apr 23, 2013 at 7:18 AM, Jeevan Chalke wrote: > Hi Tom, > > Since we are close to release, we should not have crashes like this. huh? we are not even in beta yet merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Kevin Grittner
Andres Freund wrote: > On 2013-04-23 17:48:49 +0530, Jeevan Chalke wrote: >> Hi Tom, >> >> Since we are close to release, we should not have crashes like >> this. >> >> Please have a look. My patch may not be correct as I haven't >> looked closely. > > Isn't that Kevin's departement? I'll gladly

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Andres Freund
Hi, On 2013-04-23 17:48:49 +0530, Jeevan Chalke wrote: > Hi Tom, > > Since we are close to release, we should not have crashes like this. > > Please have a look. My patch may not be correct as I haven't looked closely. Isn't that Kevin's departement? Andres -- Andres Freund

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-23 Thread Jeevan Chalke
Hi Tom, Since we are close to release, we should not have crashes like this. Please have a look. My patch may not be correct as I haven't looked closely. Thanks On Mon, Apr 22, 2013 at 7:28 PM, Jeevan Chalke < jeevan.cha...@enterprisedb.com> wrote: > > > > On Mon, Apr 22, 2013 at 6:41 PM, And

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-22 Thread Jeevan Chalke
On Mon, Apr 22, 2013 at 6:41 PM, Andres Freund wrote: > On 2013-04-22 18:35:04 +0530, Jeevan Chalke wrote: > > Hi, > > > > I have observed that following sequence is causing server crash. > > > > CREATE MATERIALIZED VIEW temp_class_mv AS > > SELECT * FROM pg_class > > WITH NO DATA; > > > > CRE

Re: [HACKERS] REFRESH MATERIALIZED VIEW command in PL block hitting Assert

2013-04-22 Thread Andres Freund
On 2013-04-22 18:35:04 +0530, Jeevan Chalke wrote: > Hi, > > I have observed that following sequence is causing server crash. > > CREATE MATERIALIZED VIEW temp_class_mv AS > SELECT * FROM pg_class > WITH NO DATA; > > CREATE OR REPLACE FUNCTION test_refresh_mv() > RETURNS int > AS $$ > BEGIN