Horton

Re: Server goes to Recovery Mode when run a SQL

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: rob stone <floriparob@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>, PegoraroF10 <marcos@f10.com.br>, pgsql-general@postgresql.org
Date: 2019-02-12T03:24:32Z
Lists: pgsql-general 
On Sun, Feb 10, 2019 at 03:15:38PM +1100, rob stone wrote:
> Down around line 87 onwards there are generate_series without any
> parameters, and further dubious usage of EPOCH, as well as DOW.
> 
> Not having the table definitions is obviously clouding the analysis.

That seems like the root issue for now.

> If there is a bug in the parser, then one of the experts will have to
> opine about that.

If you actually extract the SQL query and the schema which are used to
make the problem reproducible?  That would help a bit instead of
having to guess based on the sparse information on this thread.
--
Michael

Commits

  1. Be more careful about the shape of hashable subplan clauses.