Thread: Long column names and table names

Long column names and table names

From
david blood
Date:
How does one create a database that allows table names and column names longer
than  31 characters.  I have changed that Variable NAMEDATALEN in
src/include/postgres_ext.h configured>make>installed and then tried to
intialize a database and get this error.



Running with noclean mode on. Mistakes will not be cleaned up.
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Creating directory ../data
Creating directory ../data/base
Creating directory ../data/global
Creating directory ../data/pg_xlog
Creating template1 database in ../data/base/1
DEBUG:  database system was shut down at 2002-02-04 12:20:41 MST
DEBUG:  CheckPoint record at (0, 8)
DEBUG:  Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 16384
DEBUG:  database system is in production state
ERROR:  DefineIndex: opclass "name_ops" does not accept datatype "name"

initdb failed.



__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

Re: Long column names and table names

From
Tom Lane
Date:
Use "make clean" or even "make distclean" when altering core include
files... especially if you didn't configure --with-depend.

            regards, tom lane