On 1/16/24 10:04 PM, arun chirappurath wrote:
Architect is pressing for a native procedure to data load.
It's possible to write a loader in pl/pgsql but it would be easily twice
as complex as where you got on your first attempt. It would also never
perform anywhere near as well as a
Hi Jim,
Thank you so much for the kind review.
Architect is pressing for a native procedure to data load.
I shall Google ans try to find more suitable one than writing one by myself.
Thanks again,
Arun
On Wed, 17 Jan, 2024, 01:58 Jim Nasby, wrote:
> On 1/16/24 6:34 AM, arun chirappurath
On 1/16/24 6:34 AM, arun chirappurath wrote:
I am trying to load data from the temp table to the main table and catch
the exceptions inside another table.
I don't have a specific answer, but do have a few comments:
- There are much easier ways to do this kind of data load. Search for
"*invalid input syntax for type boolean: "15"*"
That is the problem. You can't insert 15 into a column of type "boolean".
On Tue, Jan 16, 2024 at 7:35 AM arun chirappurath
wrote:
> Dear all,
>
> I am an accidental postgres DBA and learning things every day. Apologies
> for my questions if not
On 1/16/24 06:00, Raul Giucich wrote:
Hi Arun, can you share the sql used for this insert. Visually it seems
some character are affecting the data.
Best regards,
Raul
Raul, the OP attached the sq.
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 (
arunsnm...@gmail.com) escribió:
> Dear all,
>
> I am an accidental postgres DBA and learning things every
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
