Re: [GENERAL] Importing SQLite database - Mailing list pgsql-general

From Igor Korot
Subject Re: [GENERAL] Importing SQLite database
Date
Msg-id CA+FnnTxd39TS8hWxeZ5PskmYrzo3-4=+sX5QbbD1bLgyAM3zGw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Importing SQLite database  (John R Pierce <pierce@hogranch.com>)
Responses Re: [GENERAL] Importing SQLite database
List pgsql-general
Hi,

On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce <pierce@hogranch.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.

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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: [GENERAL] huge table occupation after updates
Next
From: Sreekanth Palluru
Date:
Subject: [GENERAL] Re: [ADMIN] Would like to below scenario is possible for gettingpage/block corruption