Re: BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6
Date
Msg-id 12511.1470929044@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
Michael Paquier <michael.paquier@gmail.com> writes:
> And attached is the patch. I arrived at the conclusion that the
> assertion being broken here just needs to be relaxed a bit so as it
> understands that this code path can be taken by a matview WITH NO
> DATA. I have bundled a regression test as well. This should be
> backpatched down to 9.3.

Pushed.  The Assert was still a bit too strong: as you had it, it
still crashed on CREATE TABLE AS ... WITH NO DATA.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6
Next
From: rotten@windfish.net
Date:
Subject: BUG #14287: psql_history gets wiped out