[Openinteract-help] (Re: columnnames truncated, postgresql) found workaround

[Andreas F. <fi...@in...>]

On Mon, Jan 14, 2002 at 08:42:38AM -0500, Chris Winters wrote:
> I was hoping to get the next version of OI out before anyone using
> Postgres noticed this! :-)
> 
> SPOPS lets you specify a sequence name other than the default, so the
> latest version of the base_page package[1] has the truncated sequence
> name. The 0.55 release of SPOPS has a fix to let the custom sequence
> name work properly.
> 
> Chris
> 
> [1] http://sourceforge.net/project/showfiles.php?group_id=16810

Hi Chris,

Thanks for your reply.
I found a workaround. It took all my courage, but I looked at the postgresql
source code & after a while I found src/include/postgres_ext.h with the
definition #define NAMEDATALEN 32 

after some grepping i found that postgresql saves its relationnames, 
sequencenames, ... in a internal table called "pg_class c" as datatype "Name" 
(VARCHAR(NAMEDATALEN-1)).

I increased its value to 250, recompiled postgresql. regession tests ->
core dump.  hm.
set it to 80. recompiled. regession tests. all succeded except one: name.sql,
where postgresql tests whether "all inputs are silently truncated at 
NAMEDATALEN (32) characters". :)
So far it works. ....

another point:

I recognised that i had to do a chmod 777 $OIWEBSITE/cache, so that
httpd ("nobody") can use it. It would be good if
  oi_manage --website_name=? create_website
would do this automatically.
and $OIWEBSITE/html/{index,login}.html and $OIWEBSITE/images/* have 
permission 775. shouldn't this be 644?

anyhow,
best wishes,
 Andreas :)