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