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
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 |