Hi all.
I have PostgreSQL 16.6. The log files are attached as partitions by
file_fdw to the SQL table. Common practice. But after the error message
"trailing junk after numeric literal at or near ""512""" (vim -b view)
was wrote, the reading all log was stopped with error from file_fdw:
ERROR:
Try to look at PGQ from SkyTools.
On 2018-03-30 01:29, Cory Tucker wrote:
Is it possible to have the execution of a trigger (or any
function) not block the completion of the statement they are
associated with?
On 2018-04-27 10:55, Olivier Macchioni wrote:
> Does anyone have an idea on how to process in such a case?
>
Log statments too. :)
There is PostgreSQL 10.3 already. I have Ubuntu 17.10 (artful) and there
is not a pgdg repository for it. There is PostgreSQL 10.3 in 16.04 LTS
(xenial) pgdg repository, but such packages can't be installed on 17.10
(artful) Ubuntu. And there is zesty-pgdg (for 17.04 Ubuntu), works fine
for me
On 2018-01-22 23:15, Tom Lane wrote:
>
> It is honored as volatile: it will be re-evaluated every time the
> sub-select is re-evaluated. It's just that there's no cause to
> re-evaluate the sub-select.
>
> I poked through the SQL standard to see if it spells out the semantics
> of uncorrelated sub
Yep, interesting. Checked with PostgreSQL 10.1.
=> select *,random() from generate_series(1,10);
generate_series | random
-+---
1 | 0.308531506918371
2 | 0.126279713585973
3 | 0.984668150078505
4
