| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | rob stone <floriparob(at)gmail(dot)com> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Server goes to Recovery Mode when run a SQL |
| Date: | 2019-02-12 03:24:32 |
| Message-ID: | 20190212032432.GH1475@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Jespersen | 2019-02-12 07:57:41 | SV: Implementing pgaudit extension on Microsoft Windows |
| Previous Message | Michael Paquier | 2019-02-12 03:17:33 | Re: Promote replica before being able to accept connections |