Long column names and table names - Mailing list pgsql-general

From david blood
Subject Long column names and table names
Date
Msg-id 20020204201727.61994.qmail@web20604.mail.yahoo.com
Whole thread Raw
Responses Re: Long column names and table names
List pgsql-general
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

pgsql-general by date:

Previous
From: Frank Bax
Date:
Subject: Re: Change size of varchar(20) field
Next
From: Tom Lane
Date:
Subject: Re: Long column names and table names