Truncating column names
Linux 2.2.14
Postgres 7.0.3
DBI 1.14
I am working on Freeside and need to have above 31 character column
names. I need postgresql to stop auto-truncating when a create command is
executed.
I have tried editing /src/include/postgres_ext.h and set the NAMEDATELEN
to 64 and it still gives me a NOTICE: truncating ...
Your help is greatly appreciated.
--
Adam Rose
Systems Programmer/Jr. Systems/Network Administrator
adamr@eaze.net
Adam Rose <adamr@eaze.net> writes:
I have tried editing /src/include/postgres_ext.h and set the NAMEDATELEN
to 64 and it still gives me a NOTICE: truncating ...
That should work (did work, last I tried it). I suspect you failed to
complete the follow-through: full rebuild, reinstall, initdb.
regards, tom lane
To clarify further, I am using the RPMs from the postgresql.org
website. I installed the SRPM, changed the /src/include/postgres_ext.h,
retar-balled the postgres-7.0.3 dir, and reinstalled the rpms (rpm -e,
rpm -Uvh).
I don't know if this helps or if there is something I need to do further
(probably so). If needed, what docs explain your followup proceedure.
I really appreciate everyones help.
Adam Rose
On Fri, 23 Feb 2001, Tom Lane wrote:
Adam Rose <adamr@eaze.net> writes:
I have tried editing /src/include/postgres_ext.h and set the NAMEDATELEN
to 64 and it still gives me a NOTICE: truncating ...That should work (did work, last I tried it). I suspect you failed to
complete the follow-through: full rebuild, reinstall, initdb.regards, tom lane
--
Adam Rose
Systems Programmer/Jr. Systems/Network Administrator
adamr@eaze.net
(817)557-3038