Re: Server goes to Recovery Mode when run a SQL - Mailing list pgsql-general

From Michael Paquier
Subject Re: Server goes to Recovery Mode when run a SQL
Date
Msg-id 20190212032432.GH1475@paquier.xyz
Whole thread Raw
In response to Re: Server goes to Recovery Mode when run a SQL  (rob stone <floriparob@gmail.com>)
Responses Re: Server goes to Recovery Mode when run a SQL
List 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

Attachment

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Promote replica before being able to accept connections
Next
From: Niels Jespersen
Date:
Subject: SV: Implementing pgaudit extension on Microsoft Windows