OOO and postgres
| От | Bernhard Rohrer |
|---|---|
| Тема | OOO and postgres |
| Дата | |
| Msg-id | 4D275022.5080305@sm-wg.net обсуждение исходный текст |
| Ответы |
Re: OOO and postgres
Re: OOO and postgres Re: OOO and postgres Re: OOO and postgres |
| Список | 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 по дате отправления: