Date: Tue, 12 Feb 2019 12:24:32 +0900
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
Subject: Re: Server goes to Recovery Mode when run a SQL
Message-ID: <20190212032432.GH1475@paquier.xyz>
References: <1549209182255-0.post@n3.nabble.com>
 <1549209942200-0.post@n3.nabble.com>
 <1549660293178-0.post@n3.nabble.com>
 <20190209214651.GP31721@telsasoft.com>
 <b89edc1e814863db892ba74332ad6ccaf4eccc9f.camel@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="lrvsYIebpInmECXG"
Content-Disposition: inline
In-Reply-To: <b89edc1e814863db892ba74332ad6ccaf4eccc9f.camel@gmail.com>
Precedence: bulk


--lrvsYIebpInmECXG
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.
>=20
> 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

--lrvsYIebpInmECXG
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxiPHAACgkQnvQgOdby
QH1Tcw//Vh+ltkuvivolOH+60Jw6gpbX63DguomGuUr85AbuctBkROeyl/9zL77u
qX0Nj4ZGNhQuJ70nYojFPL466UUeey+NpJtoe57p/oCbUYPIp+WhhmQvdQR48PL2
KN4W2EkRpjqOBaADfoVOvapuRfDxVZBT9OOAqikiF7/xP9Q1FvYSYGR1gu79uWaJ
d7ePtVcMczGoWhvrONtDx8Rr6gH/xfge4M7MhFa6yyqoxdenp1eaRTJxwO0/QUyp
FuPe8gv11t2/dOpMF7b3i49B2JZ3Fi8N0JlUuV5syUwNyZaUTGUhRnufd/Q8MRRM
jmUHAtZI2j5wEYFHp0xbq8hMRlfj4V9RIhPd3DCY7FWnLhlOmv9gdi/7h1SeUwCz
mwvrKuh7Zr1vhxjIHY1y+LNS5SmP68KN4OGCNVQFrnIq0X0EKU1s2YzEtPRRUdHZ
AFUqIK/yvtwDWFnO7kgO/Md4t3amQoKHsW1JEh4D9exegokQEbS5v/sbkbxmNbr+
9laEIZL+Ey/TyR8LJtj4RJxum20A09AQkWqRmWW3J6GS7JpT439Gn9HDSm97L7+I
VmXyxpUjBKzL43hbeq3Z5uTuIstzaFZSMdzCJBJTFNgZHObo3e6D2bQNyHKoLbtD
6x6B4jhJLAwhG577hoG9m2MuCjoxxAVOwp7Vd+EmKwVb57Z6lOY=
=5GJT
-----END PGP SIGNATURE-----

--lrvsYIebpInmECXG--