Re: raising error when max length of sql object's name reached

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: david(dot)g(dot)johnston(at)gmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: raising error when max length of sql object's name reached
Date: 2018-03-28 18:50:58
Message-ID: CAN_ctnjgUQQFZbDAQH+W07pmrzhyQvwscC5rEsxVNJ-0o=S40w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ok, thanks for information
Thomas

Le mer. 28 mars 2018 à 19:57, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
a écrit :

> On Wednesday, March 28, 2018, Thomas Poty <thomas(dot)poty(at)gmail(dot)com> wrote:
>
>> Hi Community,
>>
>> Currently I works with a 9.6.7 and I wonder If PostgreSQL could raise an
>> error instead of truncate the name of a SQL object (eg: a column name, an
>> alias for a column in select statement , a table name, etc...) when the
>> length exceed 63 characters?
>>
>
> Last discussion I found was 2012.
>
>
> http://www.postgresql-archive.org/Prepared-Statement-Name-Truncation-td5732574.html
>
> In short, it likely will never be the new default and an option to control
> it is undesirable. This would be better addressed as part of static
> analysis at this point.
>
> David J.
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Heinemann, Manfred (IMS) 2018-03-29 19:57:13 RE: Function search_path
Previous Message David G. Johnston 2018-03-28 17:57:15 Re: raising error when max length of sql object's name reached