Re: Multi-row insert: error at terminal row. [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Multi-row insert: error at terminal row. [RESOLVED]
Date: 2020-10-29 22:06:47
Message-ID: alpine.LNX.2.20.2010291503380.522@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 29 Oct 2020, Rob Sargent wrote:

> Would it be rude to suggest that you re-visit how that file was made?
> Seems you'll be in the same boat "next time".

Rob,

Part of the files was exported from the old version of the database. New
rows were from different text files, each with a different format, and all
needing to be parsed with data belonging to four different tables.

There won't be a 'next time' now that I've corrected the database structure.
All new information (once I get these tables correctly loaded) will be
one-at-a-time.

Manipulating 2K datasets over long hours and multiple days led me to make
errors I didn't catch at the time.

Regards,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Loles 2020-10-30 05:23:38 Re: archive command in streaming replication in windows server
Previous Message Rob Sargent 2020-10-29 20:25:04 Re: Multi-row insert: error at terminal row. [RESOLVED]