On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <[EMAIL PROTECTED]> wrote: > Has anyone had this problem? > > while in psql: > > monashprotein=> \d alignment > ERROR: column c2.reltablespace does not exist > monashprotein=> \d region > ERROR: column c2.reltablespace does not exist > monashprotein=> > monashprotein=> \d > ERROR: relation "pg_catalog.pg_roles" does not exist > > > Any pointers would be really appreciated!
are you using an 8.x psql against a 7.x database? klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(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