^ > (caused by statement 'INSERT INTO "public"."Bladetypes" ( "ID","type") > VALUES ( '1','Knife')') > > the table looks like this: > > CREATE TABLE "Bladetypes" > ( > "ID" integer NOT NULL, > "type" character varying[] NOT NULL, > CONSTRAINT "Bladetypes_pkey" PRIMARY KEY ("ID") > )
You created type as an Array of Varchar. Was that intentional? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org