Re: Importing SQLite database

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing SQLite database
Date: 2016-12-11 02:56:12
Message-ID: CA+FnnTxd39TS8hWxeZ5PskmYrzo3-4=+sX5QbbD1bLgyAM3zGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sreekanth Palluru 2016-12-11 03:00:03 Re: [ADMIN] Would like to below scenario is possible for getting page/block corruption
Previous Message Alban Hertroys 2016-12-11 00:39:03 Re: huge table occupation after updates