Обсуждение: Cannot Create tables - on Windows XP
I have installed Postgresql 8.0 bet3 successfully. But whenever I want to create a table, be it with psql or pgAdminIII, I get the following error message: "Error:syntax error at or near "("". Could anyone help. Thanks in advance Ibrahim Shaamne
Thanks. I think I had syntax wrong while creating a table under psql. Now I have managed to create a table. But the problem persists under pgAdminIII. Here is the SQL created by pgAdminIII when attempting to create a table under it: CREATE TABLE "Maneno" ( "Neno" "char"(50), "Neno_Asilia" "char"(50) NOT NULL, "Lugha_ya_Neno" "char"(20) NOT NULL, "Tafsiri_Neno" "char"(60), "Lugha_ya_Tafsiri" "char"(20) ) WITHOUT OIDS; ALTER TABLE "Maneno" OWNER TO ibrahim; Unfortunately I cannot edit the created SQL Thanks Ibrahim Michael Glaesemann wrote: > > On Oct 27, 2004, at 3:46 PM, ishaame@bluewin.ch wrote: > >> I have installed Postgresql 8 beta3 on my windows machine, and everytime >> I issue a commond to create a table I get this message "Error: syntax error >> at or near "(" " I get this message in both pgsql and pgAdminIII. >> >> Could anyone out there help. > > > I'm willing to help, but without seeing the actual command you're using to try to create a table, it's really hard. Could you show a complete example of what you're doing? > > Michael > Michael Glaesemann > grzm myrealbox com >
On Oct 27, 2004, at 6:33 PM, ishaame@bluewin.ch wrote: > I think I had syntax wrong while creating a table under psql. Now I > have > managed to create a table. Glad to hear you got it working in psql! > But the problem persists under pgAdminIII. Here > is the SQL created by pgAdminIII when attempting to create a table > under > it: Unfortunately, I have no experience with PgAdminIII. I don't know if it's been updated to work with v8.0 (though I'm sure there are plans to do so if it hasn't been done already). > "Neno" "char"(50), It appears the problem is with the quotes around "char". I've never seen types quoted like this before (though that doesn't mean it's not valid). Removing the double quotes allowed it to work on my 8.0beta1 install. However, like you said, you probably can't change the SQL generated by PgAdminIII. I'm curious to read what people experience with PgAdminIII have to say. Good luck, Michael Glaesemann grzm myrealbox com