Στις Πέμπτη 19 Ιούλιος 2007 11:27, ο/η nilesh khode έγραψε: > Hello, > > I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 > Bit). > > I already had running Postgresql 64 bit under /var/lib/pgsql. I installed > 32 bit 2nd Postgresql using Tarball under /usr/local/pgsql. I want to cross > check whether it is 32 bit or 64 bit. So how shld I check the same?
In SELECT version(); it should say smth about the architecture. If this does not help, write a C function that checks the sizeof(void *), and compile it in both systems (64,32), and then install it on both postgresql's. Then at calling time, check its value, if its 4 then it is on a 32 bit system, if it is 8 then it is on a 64 bit system. > > Thanks, > Nilesh > > > > > > > > ___________________________________________________________________________ >_________ Get the free Yahoo! toolbar and rest assured with the added > security of spyware protection. > http://new.toolbar.yahoo.com/toolbar/features/norton/index.php > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Achilleas Mantzios ---------------------------(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
