Error in Table Creation

From: Rajnish Vishwakarma <rajnish(dot)nationfirst(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error in Table Creation
Date: 2020-06-25 04:49:49
Message-ID: CADH9T5OTEHqNtV41ExPixoQEvc4M2tfZc0w2oUsYw3i60XWXMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am creating dynamically table in PostgreSQL using psycopg2 by passing the
below 2 strings as column names:

'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load_in_PA_load'

and

'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load__in_TA_load'

And the above column names are not same ( both are different columns ) and
both the columns has string same till
*'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load__
.*

but i am getting errors as

Error:
Traceback (most recent call last):
File "C:/Users/Administrator/PycharmProjects/untitled/table_creation_with_HDA_Data.py",
line 131, in <module>
cursor.execute(sqlCreateTable)
psycopg2.errors.DuplicateColumn: column
"BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_"
specified more than once

The above columns are of type TEXT ...also it may be Numeric Type in future.

Require assistance from Postgres team on the above error.

Thanks
Rajnish Vishwakarma

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toomas Kristin 2020-06-25 06:48:03 Re: ERROR: canceling statement due to conflict with recovery
Previous Message David G. Johnston 2020-06-25 04:36:24 Re: Need help with PITR for PostgreSQL 9.4.5