Postgres Pro
Downloads
Home   >   mailing lists

Re: table name size - Mailing list pgsql-general

From David G. Johnston
Subject Re: table name size
Date
Msg-id CAKFQuwZVFJyamXKqs22XeMfoQLNWYAq_XXerVvAxB5yAQy5KDw@mail.gmail.com
Whole thread Raw
In response to table name size  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: table name size
List pgsql-general
Tree view
On Mon, Jun 13, 2016 at 7:21 AM, Sridhar N Bamandlapally <sridhar.bn1@gmail.com> wrote:
Hi

how to create table name with size, the limitation we are facing is 63 length

these are dynamic tables created from application

issue is: 
we cannot suggest/tell client to change NAMEDATALEN constant in src/include/pg_config_manual.h

do we have any other option, 


​Ensure that the application's algorithm for generating names doesn't generate names that exceed 63 characters.​

​If you're asking if there a runtime setting to control this the answer is no.​

​David J.​

pgsql-general by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: table name size
Next
From: Rakesh Kumar
Date:
Subject: Re: BDR