Re: Importing SQLite database

Thank you Adrian.
That was it.

Now I can continue testing.

On Sat, Dec 10, 2016 at 11:26 PM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 12/10/2016 06:56 PM, Igor Korot wrote:
>>
>> Hi,
>>
>> On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce <pierce(at)hogranch(dot)com>
>> wrote:
>>>
>>> On 12/10/2016 11:32 AM, Igor Korot wrote:
>>>>
>>>>
>>>> Looking
>>>> athttps://www.postgresql.org/docs/9.5/static/datatype-numeric.html,
>>>> I don't see a 'boolean' as supported data type.
>>>
>>>
>>>
>>> thats because boolean isn't a number, its a true/false value.
>>>
>>> https://www.postgresql.org/docs/current/static/datatype-boolean.html
>>
>>
>> OK, I changed all 0s to "FALSE".
>> The script did run but then failed silently (without error). No commit
>> were executed.
>
>
> Sounds like you did:
>
> BEGIN;
>
> Your commands
>
>
> and did not do a COMMIT; before exiting the session.
>
>
>>
>> Is there any way to find which statement failed?
>>
>> I can attach the script for you guys to review - I just don't know if
>> this ML OKs the attachment.
>>
>> Thank you for a suggestion.
>>
>>>
>>> --
>>> john r pierce, recycling bits in santa cruz
>>>
>>>
>>>
>>>
>>> --
>>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com