On 01/07/2011 10:16 AM, Bernhard Rohrer wrote:
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?ion
The "type" field is an array type because of the square brackets after
the data type.
"type" character varying[] NOT NULL
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_ERR
Rich Shepard wrote on 07.01.2011 18:56:
The data type is VARCHAR(), not character varying[].
character varying is a synonym for varchar, so the definition character
varying[] is valid.
It defines an array of varchar and is equivalent to varchar[]
But I doubt that this is what the OP meant ;)
rg
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bernhard Rohrer
Sent: Friday, January 07, 2011 9:41 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] OOO and postgres
Hi guys
I am using the postgres driver for OOO and just ran into the following
error:
Error code: 1
pq_driver: [
On Fri, 7 Jan 2011, Bernhard Rohrer wrote:
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;
ALT
On 01/07/2011 09:40 AM, Bernhard Rohrer wrote:
Hi guys
I am using the postgres driver for OOO and just ran into the following
error:
Error code: 1
If you are referring to OpenOffice and the native SDBC driver then from
the docs:
http://dba.openoffice.org/drivers/postgresql/index.html#fea
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')
