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
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 |