Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I changed the length of table names in PostgreSQL in the file pg_config_manual.h (in C:\Program Files\PostgreSQL\9.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.

share|improve this question

migrated from Jan 20 '12 at 12:25

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.