Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1g2XGS-0005Gj-13
	for pgsql-admin@arkaria.postgresql.org; Wed, 19 Sep 2018 07:51:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1g2XGQ-0006EU-F5
	for pgsql-admin@arkaria.postgresql.org; Wed, 19 Sep 2018 07:51:10 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <mark.kirkwood@catalyst.net.nz>)
	id 1g2XGQ-0006EN-7d
	for pgsql-admin@lists.postgresql.org; Wed, 19 Sep 2018 07:51:10 +0000
Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <mark.kirkwood@catalyst.net.nz>)
	id 1g2XGK-0007kp-UD
	for pgsql-admin@lists.postgresql.org; Wed, 19 Sep 2018 07:51:08 +0000
Authentication-Results: auth=pass smtp.auth=mark.kirkwood@catalyst.net.nz
 smtp.mailfrom=mark.kirkwood@catalyst.net.nz
Received: from [IPv6:2406:e001:8a2:1:a0c2:dcf3:661e:b5ad] (unknown
 [IPv6:2406:e001:8a2:1:a0c2:dcf3:661e:b5ad])
	(Authenticated sender: mark.kirkwood@catalyst.net.nz)
	by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id
 0946880B40;
	Wed, 19 Sep 2018 19:50:56 +1200 (NZST)
Subject: Re: sqlite_fdw crashes & errors
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: andrew@tao11.riddles.org.uk, pgsql-admin@lists.postgresql.org
References: 
 <CA+t6e1kzja9ats3yLtLYo4jY52h-cNiMxt7zyEgQixHx=vazKQ@mail.gmail.com>
 <534fa6d9-4541-bb7d-a26c-3c021690cc4b@catalyst.net.nz>
 <CA+t6e1njA-BnjqDeAJ9gdzhhfFYhBtKsfnxceFh0BLphM=yonw@mail.gmail.com>
 <3e05aedb-987b-29aa-bb5e-e89bfd372834@catalyst.net.nz>
 <CA+t6e1=h+814eAbv=1Etq_EZ-4PhKF+3cJpi+m3ZUOAU6aGpFw@mail.gmail.com>
 <170c1a6b-651a-4ae8-6ea3-4ce1ab54275f@catalyst.net.nz>
 <CA+t6e1=PHY0S9h6mvPn6A6EFn7trUsq3+uvcx9=JfqzkthesZA@mail.gmail.com>
 <CA+t6e1kAW1wzH_ogge9E3e0yG8feM092Oh5bKjig+u3irp6nkw@mail.gmail.com>
 <CA+t6e1=hiby+-PG1gY3MwEmu9PvTQGztURej-wZuZ=iJ0HhCqg@mail.gmail.com>
 <87sh27hrxj.fsf@news-spur.riddles.org.uk>
 <CA+t6e1kZNsdLw6bRhhzKrjDsr784sES_FErb-5dXhi5EJKoD7Q@mail.gmail.com>
 <87k1njhqxp.fsf@news-spur.riddles.org.uk>
 <63820e86-991e-fa2e-4e1c-4596aae14fb7@catalyst.net.nz>
 <CA+t6e1=eNWEcb8=L1Rqpj10yeU8eXpBHVEDmSSo0nFSHWJdapw@mail.gmail.com>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Message-ID: <da5c3c30-5c49-58cf-92bf-59cdbd0d2b41@catalyst.net.nz>
Date: Wed, 19 Sep 2018 19:50:55 +1200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CA+t6e1=eNWEcb8=L1Rqpj10yeU8eXpBHVEDmSSo0nFSHWJdapw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

On 19/09/18 17:08, Mariel Cherkassky wrote:

> But in my case i'm not getting the error you got. Instead, my postgres 
> instance crashes.
>
>     >
>     > 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.
>

^^^ My method of making it error appears to have sql text, somehow in 
your case there is none (which is interesting), but maybe not worth 
investigating as there is obviously a bug in the error handling - we can 
retest when it is patched!

regards
Mark