Re: base and postgres

Josh Berkus <[email protected]> Fri, 07 Jan 2011 10:14:10 -0800
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
                                                               ^
>  (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