Ahem... the postgresql version on the server is 7.2.1-2woody2. Sam.
On Wed, 2 Jul 2003, scott.marlowe wrote: > What he meant was what VERSION of postgresql is the server using. :-) > > On Wed, 2 Jul 2003, S.Peppe wrote: > > > Thanks for your reply, Tom. The server I'm connecting to is only about 3 > > months old - that shouldn't be the problem then, as far as I can > > tell. Thanks again. > > > > Regards, > > > > Sam. > > > > On Wed, 2 Jul 2003, Tom Lane wrote: > > > > > "S.Peppe" <[EMAIL PROTECTED]> writes: > > > > it returns this: > > > > ERROR: Relation "pg_user" does not exist > > > > > > Uh ... how old is the server you're connecting to, exactly? > > > > > > The pg_user view has been standard for awhile, I can't blame your > > > psql for assuming it exists ... > > > > > > regards, tom lane > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to choose an index scan if your > > joining column's datatypes do not match > > > > -- ********************************************************** Dr. Sam Peppe Tel : +44 (0)23 8059 3587 Postdoctoral Research Fellow Fax : +44 (0)23 8059 3781 Department of Chemistry Email : [EMAIL PROTECTED] University of Southampton HANTS SO17 1BJ http://www.combechem.org/ ********************************************************** ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]