Re: OOO and postgres

What I am not getting is - as far as I can see none of the fields _is_
an array! So why would this error message appear?

On 07/01/11 17:40, Bernhard Rohrer wrote:
> Hi guys
>
> I am using the postgres driver for OOO and just ran into the following
> error:
>
> Error code: 1
>
> pq_driver: [PGRES_FATAL_ERROR]ERROR:  array value must start with "{"
> or dimension information
> LINE 1: ...O "public"."Bladetypes" ( "ID","type") VALUES ( '1','Knife')
>                                                                ^
>  (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")
> )
>
> 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;
>
> is this for this list?
>
> Thanks
>
> Bernhard
>