Hi Jayadevan,
Actually this was done by system administrator.
I will redo the things with pgsql 9 tar.gz file and get back to you.
Thanks a lot for bringing this to my notice.
Thanks for the query "select version();"
Regards,
Rekha.
Jayadevan M wrote:
Hi,
  
I got the following result.

 PostgreSQL 7.4.13 on i686-redhat-linux-gnu, compiled by GCC gcc 
(GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
It seems it shows the version from which I took the database to dump.
    
Didn't you upgrade from 8.1 to 9? Where did 7.4 come from? How did you 
upgrade?
Regards,
Jayadevan



  


Business Disclaimer
____________________________________________________________
This e-mail message and any files transmitted with it are intended solely
for  the use  of the  individual or entity  to which they  are  addressed. It
may  contain confidential,  proprietary or legally  privileged  information.
If  you  are  not  the  intended recipient please be advised that you have
received  this  message in error and any use is strictly prohibited. Please
immediately  delete it  and all copies of it from your system, destroy any
hard  copies  of  it and  notify  the  sender  by return mail. You must not,
directly or indirectly, use,  disclose,  distribute, print, or copy any part of
this message if you are not the intended recipient.
___________________________________________________________