From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Rajnish Vishwakarma <rajnish(dot)nationfirst(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Error in Table Creation |
Date: | 2020-06-25 09:05:00 |
Message-ID: | CABUevEwYWSsmXttjetn2qqD0x+hx81W4qYhi7a4uoX_jR1OHqg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jun 25, 2020 at 10:59 AM Rajnish Vishwakarma <
rajnish(dot)nationfirst(at)gmail(dot)com> wrote:
> 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.
>
>
By default the maximum length of a column name (or other names) in postgres
is 63 characters, see
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS)
You are trying to create columns with names that are way longer than that,
so they will be truncated. If you create this table in psql it will show
you a NOTICE information about this -- I believe in psycopg2 this shows up
in conn.noticies (where conn is the connection object from psycopg2).
And truncated to 63 characters they *are* the same name. (Those are some
crazy long column names btw..)
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Klaudie Willis | 2020-06-25 09:39:00 | Re: n_distinct off by a factor of 1000 |
Previous Message | Guillaume Lelarge | 2020-06-25 09:04:07 | Re: Error in Table Creation |