On Fri, 7 Jan 2011, Bernhard Rohrer wrote:
CREATE TABLE "Bladetypes" ( "ID" integer NOT NULL, "type" character varying[] NOT NULL, CONSTRAINT "Bladetypes_pkey" PRIMARY KEY ("ID") )ALTER TABLE "Bladetypes" ADD COLUMN "ID" integer; ALTER TABLE "Bladetypes" ALTER COLUMN "ID" SET NOT NULL; ALTER TABLE "Bladetypes" ADD COLUMN "type" character varying[]; ALTER TABLE "Bladetypes" ALTER COLUMN "type" SET NOT NULL;
Don't use double quotes in your create table stanza. You can use them on the table name with alter table and insert into. The data type is VARCHAR(), not character varying[]. Why are you altering the table to be exactly how you defined it? Use single quotes to define text strings in your values statements. Perhaps you'll find value in reading a book on SQL. Rick van der Lans and Joe Celko both write outstanding books on the language and its use. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
