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 <[email protected]> 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 <[email protected]> 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
>>
>>
>
