Hi, I am perplexed. I tried to change the type of a column using the syntax I found in the [ALTER TABLE] section: 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 It seems like it doesn't like the "type". My compiler-experience tells me that the column identifier is somehow broken. But it exists! What went wrong? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly