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