Re: base and postgres
Bernhard Rohrer <[email protected]> Fri, 07 Jan 2011 18:30:43 +0000
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
On 07/01/11 18:14, Josh Berkus wrote:
> ^
>> (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")
>> )
> You created type as an Array of Varchar. Was that intentional?
>
>
nope. where does it say that? I created it using the driver, specifying
memo(_varchar) as data type. what should i have done instead?
Thanks!
Bernhard