Identifier gets truncated

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Identifier gets truncated
Date: 2013-01-10 14:36:32
Message-ID: CAOh+DOn0aaS+frERqQA9NsGDZt_YfUUGfEfvThi8S-rkubqMSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When an identifier has more then 63 chars it gets truncated.
This is fine.
However PostgreSQL fails to notice that it might truncate to an identifier
which already exist.
Does PostgreSQL got a setting that will never create a duplicate identifier?

really_long_name_table_A -> really_long_na
really_long_name_table_B -> really_long_na

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fujii Masao 2013-01-10 14:50:31 Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Previous Message Gavan Schneider 2013-01-10 11:11:56 Re: query by partial timestamp