From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
---|---|
To: | mark(dot)kirkwood(at)catalyst(dot)net(dot)nz |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: sqlite_fdw crashes & errors |
Date: | 2018-09-18 06:40:19 |
Message-ID: | CA+t6e1njA-BnjqDeAJ9gdzhhfFYhBtKsfnxceFh0BLphM=yonw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
What version of sqlite did you use ?
בתאריך יום ג׳, 18 בספט׳ 2018 ב-3:49 מאת Mark Kirkwood <
mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>:
> On 17/09/18 00:01, Mariel Cherkassky wrote:
> > Hi,
> > I installed sqlite_fdw(https://github.com/pgspider/sqlite_fdw) on my
> > postgresql v9.6.
> > As mentioned on the github page, the extension supports writes.
> >
> > However, When I try to insert record into my foreign table my
> > postgresql crushes :
> >
> > sqlite> .schema MARIEL_TEST
> > CREATE TABLE MARIEL_TEST( cola INTEGER PRIMARY KEY, colb TEXT, colc
> > INTEGER);
> >
> > db=# CREATE FOREIGN TABLE MARIEL_TEST_foreign(cola integer,
> > colbtext,colc integer) SERVER sqlite_server OPTIONS (table
> 'MARIEL_TEST');
> > CREATE FOREIGN TABLE
> > afa=# insert into MARIEL_TEST_foreign values(1,1,1);
> > server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
> > !>
> > !> .exit
> > -> ;
>
> Just tried this (Postgres 9.6.10 src build and sqlite_fdw on Ubuntu
> 18.04). Works for me. Hmmm interesting. I did one thing different from
> you - my sqlite db is under Postgres home dir (/home/postgres/sqlite).
> Thinking for a bit ... did you create the sqlite db as the postgres user
> or someone else? If the latter then that might explain the crash (e.g
> permission denied).
>
> Cheers
> Mark
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mariel Cherkassky | 2018-09-18 07:47:09 | Re: Segmentation fault postgres 9.6 |
Previous Message | Mark Kirkwood | 2018-09-18 00:49:41 | Re: sqlite_fdw crashes & errors |