On May 7, 2007, at 9:11 AM, Tom Lane wrote:
I believe BTW that you
need to do "sudo ipcs -a" to be sure of seeing everything; otherwise
OS X's ipcs silently doesn't tell you about segments your userid
doesn't
have access to.
Actually, it seems that you don't get anything back when ipcs is run
as non-root...
[EMAIL PROTECTED]:41]~/pgsql/HEAD:58%ipcs -a|grep decibel
[EMAIL PROTECTED]:41]~/pgsql/HEAD:59%sudo ipcs -a|grep decibel
m 3080191 5555001 --rw------- decibel decibel decibel
decibel 3 38133760 11042 11042 9:00:53 10:41:53 9:00:53
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(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
