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

[Chris W. <ch...@cw...>]

On Tue, 2002-01-15 at 03:53, Andreas Fitzner wrote:
> 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. ...

Wow. I'll keep this in mind as an alternate method :-)
 
> 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.

Actually, I think I'll put this in the INSTALL.website since we (a)
don't know what user the website is running under and (b) run on
non-Unix OSes.

> and $OIWEBSITE/html/{index,login}.html and $OIWEBSITE/images/* have 
> permission 775. shouldn't this be 644?

Maybe so. However, don't people also run servers so that the webserver
*group* has read/write permissions to the files? Or maybe not...

I will also put this in the INSTALL.website as 'Permission issues' or
something.

Thanks,

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.