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