Error in Table Creation - Mailing list pgsql-general

From Rajnish Vishwakarma
Subject Error in Table Creation
Date
Msg-id CADH9T5OTEHqNtV41ExPixoQEvc4M2tfZc0w2oUsYw3i60XWXMQ@mail.gmail.com
Whole thread Raw
Responses Re: Error in Table Creation
Re: Error in Table Creation
List 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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Need help with PITR for PostgreSQL 9.4.5
Next
From: Toomas Kristin
Date:
Subject: Re: ERROR: canceling statement due to conflict with recovery