Error in Table Creation

Поиск
Список
Период
Сортировка
От Rajnish Vishwakarma
Тема Error in Table Creation
Дата
Msg-id CADH9T5OTEHqNtV41ExPixoQEvc4M2tfZc0w2oUsYw3i60XWXMQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error in Table Creation  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Error in Table Creation  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Need help with PITR for PostgreSQL 9.4.5
Следующее
От: Toomas Kristin
Дата:
Сообщение: Re: ERROR: canceling statement due to conflict with recovery