0

I changed the length of table names in PostgreSQL in the file pg_config_manual.h (in C:\Program Files\PostgreSQL9円.1\include) to 128. Then I reloaded the new configuration by selecting menu "Reload Configuration" under the menu PostgreSQL 9.1 in start menu. Also, I restarted the PostgreSQL. But the change did not take effect. Length of table names in my database still has the limit 64 characters.

How to solve this problem? I am using PostgreSQL 9.1 on Windows 7 Professional.

JNK
18.1k6 gold badges63 silver badges98 bronze badges
asked Jan 20, 2012 at 3:30

2 Answers 2

4

pg_config_manual.h is not a configuration file, it's part of the source code. After a change in the source code, you have to compile all the code and install the program you just compiled.

Changing the max length for names is not trivial.

answered Jan 20, 2012 at 7:14
3

in this case, you need recompile PostgreSQL source code. Any changes in pg_config_manual.h needs recompilation - this is not classical config.

answered Jan 20, 2012 at 7:13

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.