Am Dienstag, 28. Februar 2006 07:42 schrieb Christopher Kings-Lynne: > I just tried using ipcclean in 8.1.3. It doesn't work when I su to the > pgsql user. This part of the script: > > if [ "$USER" = 'root' -o "$LOGNAME" = 'root' ] > > Always fails because even tho $USER is set to 'pgsql' when su'ed, > $LOGNAME is still root. > > This is on FreeBSD 4.9
It seems to work on Linux; apparently there are different behaviors of su. Do you have a suggestion for resolving this? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match