From: | Raul Giucich <raul(dot)giucich(at)gmail(dot)com> |
---|---|
To: | arun chirappurath <arunsnmimt(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: postgres sql assistance |
Date: | 2024-01-16 13:00:03 |
Message-ID: | CAN0zQZ4MpdR3VZD1nxOm2yo7kurzweypZrte3jryBnTtPajiDw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Arun, can you share the sql used for this insert. Visually it seems some
character are affecting the data.
Best regards,
Raul
El mar, 16 ene 2024 a la(s) 9:35 a.m., arun chirappurath (
arunsnmimt(at)gmail(dot)com) escribió:
> Dear all,
>
> I am an accidental postgres DBA and learning things every day. Apologies
> for my questions if not properly drafted.
>
> I am trying to load data from the temp table to the main table and catch
> the exceptions inside another table.
>
> temp table is cast with the main table data type and trying to load the
> data.
>
> temp table is below.
>
> category_name | description
> | is_active
>
> -------------------------------------------+---------------------------------------------+-----------
> *Tech123212312312323233213123123123123 *| Furniture and home decor
> | true
> *Tech123212312312323233213123123123123 *| Electronic devices and
> accessories | true
> Elec | Books of various genres
> | *15*
> TV | Books
> | *12*
> cla | Apparel and fashion accessories
> | true
>
> category name is varchar(25) and is_active is boolean in main table. So i
> should get exceptions for 1st,2nd for category_name rows and 4 and 5th rows
> for boolean. In exception table results,its only showing
>
> Exception table is below. Here instead of showing exception for value 12
> in the is_active table its showing old exception for 15 itself.. Script is
> attached,,...SQLERRM value is not getting updated for row 12..WHat could be
> the reason for this?
>
> value too long for type character varying(25) category_name 1 2024-01-16
> 16:17:01.279 +0530 value too long for type character varying(25)
> description 2 2024-01-16 16:17:01.279 +0530 invalid input syntax for type
> boolean: "15" is_active 3 2024-01-16 16:17:01.279 +0530 *invalid input
> syntax for type boolean: "15" * 4 2024-01-16 16:17:01.279 +0530 *invalid
> input syntax for type boolean: "15"* 5 2024-01-16 16:17:01.279 +0530
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2024-01-16 13:24:49 | Re: Nested-Internal Functions |
Previous Message | Karsten Hilbert | 2024-01-16 12:53:20 | Aw: Nested-Internal Functions |