OOO and postgres - Mailing list pgsql-general

From Bernhard Rohrer
Subject OOO and postgres
Date
Msg-id 4D275022.5080305@sm-wg.net
Whole thread Raw
Responses Re: OOO and postgres  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: OOO and postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: OOO and postgres  (Susan Cassidy <scassidy@stbernard.com>)
Re: OOO and postgres  (Bernhard Rohrer <graylion@sm-wg.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Backup and restore sequences
Next
From: Adrian Klaver
Date:
Subject: Re: OOO and postgres