APL: db←'postgresql' SQL∆Connect 'host=localhost user=postgres password=postgres dbname=apl' db 'select * from apl_files;' SQL∆Select[db]''
PostgreSQL: $ psql apl postgres psql (9.1.13) Type "help" for help. apl=# \dt List of relations Schema | Name | Type | Owner --------+-----------+-------+---------- public | apl_files | table | postgres (1 row) apl=# select * from apl_files; file_name ----------- (0 rows) apl=# Thanks! Blake On Fri, May 9, 2014 at 9:06 AM, Elias Mårtenson <loke...@gmail.com> wrote: > What is the query you ran, and what was the content of the database table? > > I won't be able to test this on a real Postgres instance until I get back > home (on Monday), but this information may at least give me an idea. > > Regards, > Elias > > > On 9 May 2014 21:58, Blake McBride <blake1...@gmail.com> wrote: > >> Greetings, >> >> I've got my keyed file system running on sqlite. As soon as I started >> testing it under PostgreSQL I got some errors. I am thinking that it is >> possible that you still needed to change the PostgreSQL stuff to match the >> other changes you had to make for the new API. This is the error I get: >> >> Thanks! >> >> >> >> ============================================================================== >> Assertion failed: 0 >> in Function: init >> in file: Cell.cc:48 >> >> Call stack: >> >> ---------------------------------------- >> -- Stack trace at Cell.cc:48 >> ---------------------------------------- >> 0x7f3b16e95de5 __libc_start_main >> 0x4359fd main >> 0x52993d Workspace::immediate_execution(bool) >> 0x46504d Command::process_line() >> 0x463ec3 Command::process_line(UCS_string&) >> 0x46f4e8 Executable::execute_body() const >> 0x4e4040 StateIndicator::run() >> 0x491f9a Prefix::reduce_statements() >> 0x48db6e Prefix::reduce_V_ASS_B_() >> 0x4f4386 Symbol::assign(Value_P, char const*) >> 0x52600b Value::clone(char const*) const >> 0x45b3e1 Cell::init(Cell const&) >> 0x44386f do_Assert(char const*, char const*, char const*, int) >> ======================================== >> >> SI stack: >> >> Depth: 2 >> Exec: 0x2602448 >> Pmode: ∇ SQL∆Select[1] >> PC: 10 ENDL >> Stat: Z←X SQL[3,db] Y >> err_code: 0x0 >> thrown: at StateIndicator.cc:40 >> e_msg_1: 'No Error' >> e_msg_2: '' >> e_msg_3: '' >> >> Depth: 1 >> Exec: 0x25e6708 >> Pmode: ∇ KF∆Files[1] >> PC: 6 ← >> Stat: files←'select file_name from apl_files;' SQL∆Select[db]'' >> err_code: 0x0 >> thrown: at StateIndicator.cc:40 >> e_msg_1: 'No Error' >> e_msg_2: '' >> e_msg_3: '' >> >> Depth: 0 >> Exec: 0x26011a0 >> Pmode: ◊ db KF∆Files db >> PC: 3 ENDL >> Stat: db KF∆Files db >> err_code: 0x0 >> thrown: at StateIndicator.cc:40 >> e_msg_1: 'No Error' >> e_msg_2: '' >> e_msg_3: '' >> >> >> >> ============================================================================== >> >> >> ==================================================== >> SEGMENTATION FAULT >> >> ---------------------------------------- >> -- Stack trace at main.cc:122 >> ---------------------------------------- >> 0x7f3b16e95de5 __libc_start_main >> 0x4359fd main >> 0x52993d Workspace::immediate_execution(bool) >> 0x46504d Command::process_line() >> 0x463ec3 Command::process_line(UCS_string&) >> 0x46f4e8 Executable::execute_body() const >> 0x4e4040 StateIndicator::run() >> 0x491f9a Prefix::reduce_statements() >> 0x48db6e Prefix::reduce_V_ASS_B_() >> 0x4f4386 Symbol::assign(Value_P, char const*) >> 0x52600b Value::clone(char const*) const >> 0x45b3e1 Cell::init(Cell const&) >> 0x443817 do_Assert(char const*, char const*, char const*, int) >> 0x50131c TestFiles::assert_error() >> 0x7f3b186efbb0 >> 0x47f0aa >> ======================================== >> ==================================================== >> >> Process apl segmentation fault >> >> >