All, I am new to postgreSQL and the first time I tried to execute postgres.exe I got an error saying the services must be started as a non-administrative windows user. But I checked the doc and it says after 8.2 it is possible to run postgres.exe as a windows administrator. So a little bit confused, is it possible, if so, how? Thanks a lot for help! ---------------------------(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