Re: Mac OS X, PostgreSQL, PL/Tcl

I'm certain that the length of a single env var is the only factor 
involved, and not the size of the enviroment itself. If I login to my 
normal environment and unset LS_COLORS, everything works fine. If I 
move my .bashrc out of the way, login fresh and create an env var > 522 
chars, it fails. My login environment is much larger than the 
environment I get without . bashrc, and the results of setting a single 
env var to > 522 chars duplicates the problem in both envs. leading me 
to believe that env size doesn't have an effect on this problem. I've 
now set my PG startup script to 'unset LS_COLORS' before starting PG, 
and this works great. Has anyone else tried to duplicate this problem? 
I'm using Mac OS 10.3.2, PG 7.4.1, Tcl 8.4.5.

/s.


On Feb 22, 2004, at 12:21 PM, Tom Lane wrote:

> Scott Goodwin <scott@scottg.net> writes:
>> Found the problem. If I have a very long environment variable exported
>> and I start PG, PG crashes when I try to load PG/Tcl. In my case I use
>> color ls and I have a very long LS_COLORS environment variable set.
>
> Interesting.  Did you check whether the limiting factor is the longest
> variable length, or the total size of the environment?  ("env|wc" would
> probably do as an approximation for the latter.)
>
>             regards, tom lane
>