On Wed, Jan 12, 2005 at 06:02:10PM +0100, KÖPFERL Robert wrote: > ALTER TABLE "Mailboxes" ALTER COLUMN "Status" TYPE int4; > > This shuld be no problem since the current type acutally is int4 and the > names are copy'n'pasted. The server responds as follows: > > ERROR: syntax error at or near "TYPE" at character 47
That's exactly the error you'd get on a pre-8.0 system that doesn't support altering a column's type. Are you looking at 8.0 documentation but running a 7.x server? What does "SELECT version();" show? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
