Long column names and table names

From: david blood <davidjblood(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Long column names and table names
Date: 2002-02-04 20:17:27
Message-ID: 20020204201727.61994.qmail@web20604.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-02-04 20:17:36 Re: Solaris Performance
Previous Message Frank Bax 2002-02-04 20:12:03 Re: Change size of varchar(20) field