Re: sqlite_fdw crashes & errors

But in my case i'm not getting the error you got. Instead, my postgres
instance crashes.

‫בתאריך יום ד׳, 19 בספט׳ 2018 ב-2:02 מאת ‪Mark Kirkwood‬‏ <‪
mark(dot)kirkwood(at)catalyst(dot)net(dot)nz‬‏>:‬

> On 19/09/18 01:33, Andrew Gierth wrote:
> >>>>>> "Mariel" == Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> writes:
> > Mariel> So, how exactly it works for other people ? Shouldnt everyone
> > Mariel> who use this extension should have suffered from this bug ? And
> > Mariel> why for selects it works fine ?
> >
> > The bug is in error reporting, so it kicks in only when an error occurs
> > and then only when a null value for the sql text is passed to the
> > reporting function.
> >
> Ah right - I guess I was not tickling the bug correctly:
>
> $ chmod 444 sqlite/test.db
> $
>
> $ psql
>
> =# insert into MARIEL_TEST_foreign values(4,1,1);
> ERROR: failed to execute remote SQL: rc=1 SQL logic error
> sql=INSERT INTO main."MARIEL_TEST"("cola", "colb", "colc") VALUES (?,
> ?, ?)
>
> regards
>
> Mark
>
>