Re: table name size

[Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx>]

Hi

Is there any specific reason not releasing any version with "NAMEDATALEN 255" in file src/include/pg_config_manual.h ?

this will really nice if we do with "NAMEDATALEN 255" src/include/pg_config_manual.h

Please

Thanks

Sridhar

OpenText

On Mon, Jun 13, 2016 at 5:40 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Mon, Jun 13, 2016 at 7:21 AM, Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx> 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.​