Re: Table copy

From: Andy Hartman <hartman60home(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Table copy
Date: 2025-02-05 22:58:06
Message-ID: CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Reduce batch size still caused error as reported nothing in WIndows Server
log...

The SimplySql is slick because just qry from src and load to dst ... Is
there any way to somehow show more of the error in PS i tried the $error
but nothing very descriptive

On Wed, Feb 5, 2025 at 4:23 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 2/5/25 13:09, Andy Hartman wrote:
> > I also reduced batch size to 5000 on the last run .. I like using this
> > SImplySql because it's a script I can launch, so that's why I chose that
> > solution... I'm using it to load a History Env.
>
> You really need to complete your thoughts, remember we have no idea what
> you are seeing unless you tell us.
>
> Reducing the batch size did what?
>
>
> >
> > THanks again.
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Hartman 2025-02-05 22:59:10 Re: Table copy
Previous Message Thiemo Kellner 2025-02-05 22:36:10 Re: Lookup tables