Hi,
I am running postgresql 7.2.2-1.
Best,
David
On Fri, Sep 15, 2006 at 09:20:28AM +0800, [EMAIL PROTECTED] wrote:
> this is the command output
>
> lrwxrwxrwx 1 root root 4 Apr 3 2003 /bin/sh -> bash
> -rwxr-xr-x 1 root root 9468 Sep 5 2002 /usr/bin/pg_ctl
> -rwxr-xr-x 1 root root 3074760 Sep 5 2002 /usr/bin/postgres
> lrwxrwxrwx 1 root root 8 Oct 29 2005 /usr/bin/postmaster ->
> postgres
What version of PostgreSQL are you running? If those dates are
correct then I'd guess 7.2.x or earlier.
What about the output of the su command?
--
Michael Fuhr
---------------------------(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
