Re: sqlite_fdw crashes & errors - Mailing list pgsql-admin

From Mariel Cherkassky
Subject Re: sqlite_fdw crashes & errors
Date
Msg-id CA+t6e1=eNWEcb8=L1Rqpj10yeU8eXpBHVEDmSSo0nFSHWJdapw@mail.gmail.com
Whole thread Raw
In response to Re: sqlite_fdw crashes & errors  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: sqlite_fdw crashes & errors
List pgsql-admin
But in my case i'm not getting the error you got. Instead, my postgres instance crashes.

‫בתאריך יום ד׳, 19 בספט׳ 2018 ב-2:02 מאת ‪Mark Kirkwood‬‏ <‪mark.kirkwood@catalyst.net.nz‬‏>:‬
On 19/09/18 01:33, Andrew Gierth wrote:
>>>>>> "Mariel" == Mariel Cherkassky <mariel.cherkassky@gmail.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

pgsql-admin by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: sqlite_fdw crashes & errors
Next
From: Mark Kirkwood
Date:
Subject: Re: sqlite_fdw crashes & errors