Re: DB insert Error

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: DB insert Error
Date: 2006-08-16 04:38:42
Message-ID: a47902760608152138m20975f1cr884f4ce525803aba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

table definition of raw_email table is as follows

CREATE TABLE raw_email (
id int4 NOT NULL,
raw_email varchar[],
parsed_flag bool NOT NULL DEFAULT false,
CONSTRAINT pk_rawemail PRIMARY KEY (id)
)
WITHOUT OIDS;

i have very much declared raw_email field as varchar and not char

~Jas

On 8/16/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Tue, Aug 15, 2006 at 11:55:58PM -0400, Jasbinder Bali wrote:
> > I'm using ECPG and trying to do follwoing insert in one of the talbes.
> >
> > insert into raw_email ( id , raw_email ) values ( 1 , :ch);
> >
> > ch is an array and defined as follows:
> >
> > EXEC SQL BEGIN DECLARE SECTION;
> > char ch[MSG_LEN];
> > EXEC SQL END DECLARE SECTION;
> >
> > contents of array ch is actually a parsed raw email that i've attached
> > herewith.
> >
> > I get the following error when the insert statement is hit:
> >
> > [2446]: ECPGexecute line 97: Error: ERROR: array value must start with
> "{"
> > or dimension information.
>
> What's the table definition for raw_email? Based on the error it
> looks like one of the columns you're inserting is defined as an
> array. I'm guessing you did something like this:
>
> CREATE TABLE raw_email (
> id integer,
> raw_email char[]
> );
>
> When you should have done this:
>
> CREATE TABLE raw_email (
> id integer,
> raw_email text -- or varchar
> );
>
> Is my guess correct?
>
> --
> Michael Fuhr
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aBBISh 2006-08-16 04:43:07 how to use variable for select query in pl/pgsql
Previous Message Jasbinder Bali 2006-08-16 04:30:18 Re: [GENERAL] DB insert Error

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-08-16 05:05:29 Re: DB insert Error
Previous Message Jasbinder Bali 2006-08-16 04:30:18 Re: [GENERAL] DB insert Error