From: | Bernhard Rohrer <graylion(at)sm-wg(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: OOO and postgres |
Date: | 2011-01-07 18:16:38 |
Message-ID: | 4D275886.5070001@sm-wg.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-01-07 18:23:40 | Re: OOO and postgres |
Previous Message | Thomas Kellerer | 2011-01-07 18:15:08 | Re: OOO and postgres |