[ADMIN] NAMEDATALEN change

2007-08-14 Thread Gregory Williamson
We need to change the maximum length of table/column name lengths, and it looks as if changing NAMEDATALEN in src/include/postgres_ext.h and recompiling postgres. 2 questions: a) Do I need to dump the database and reload ? (my guess is yes but only a guess ...) b) any caveats or warnings

Re: [ADMIN] NAMEDATALEN change

2007-08-14 Thread Tom Lane
Gregory Williamson [EMAIL PROTECTED] writes: a) Do I need to dump the database and reload ? Yes. (Any reasonably modern backend will in fact refuse to start if pg_control shows an incompatible nameDataLen.) This is not a lot different from changing --enable-integer-datetimes, for instance.