Re: [NOVICE] DB insert Error

Also, i tried to mannualy run the insert query in the query tool

------------------------------------------------------------

insert into raw_email ( id , raw_email ) values ( 1 , 'From
simon(at)simon-cozens(dot)org Tue Apr 15 20:24:47 2003
X-MultiHeader: one
X-MultiHeader: two
X-MultiHeader: three
From: Simon Cozens <simon(at)simon-cozens(dot)org>
To: test
Bcc: simon(at)twingle(dot)net
Subject: foo
Mime-Version: 1.0
Content-Type: image/gif
Content-Disposition: attachment; filename="1.gif"
Content-Transfer-Encoding: base64
X-Operating-System: Linux deep-dark-truthful-mirror 2.4.9
X-POM: The Moon is Waxing Gibbous (98% of Full)
X-Addresses: The simon(at)cozens(dot)net address is deprecated due to being broken.
simon(at)brecon(dot)co(dot)uk still works, but simon-cozens.org or netthink.co.uk are
preferred.
X-Mutt-Fcc: =outbox-200304
Status: RO
Content-Length: 1205
Lines: 17

R0lGODlhDAAMAPcAAAAAAAgICBAQEBgYGCkpKTExMTk5OUpKSoyMjJSUlJycnKWlpbW1tc7O
zufn5+/v7/f39///////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
/////////////////////////////////ywAAAAADAAMAAAIXwAjRICQwIAAAQYUQBAYwUEB
AAACEIBYwMHAhxARNIAIoAAEBBAPOICwkSMCjBAXlKQYgCMABSsjtuQI02UAlC9jFgBJMyYC
CCgRMODoseFElx0tCvxYIEAAAwkWRggIADs=

' )

------------------------------------------------------------

But it doesn't store the full raw_email field contents

raw_email field has just the follwing stored in it

-----------------------------------------------
"From simon(at)simon-cozens(dot)org Tue Apr 15 20:24:47 2003
X-MultiHeader: one
X-MultiHeader: two
X-MultiHeader: three
From: Simon Cozens <simon(at)simon-cozens(dot)org>
To: test
Bcc: simon(at)twingle(dot)net
Subject: foo
Mime-Version: 1.0
Content-Type: image/gif
Content-Dispo (..)"
-----------------------------------------------

Also, as i've already told, even after i commit my transaction, it doesn't
insert the record.

Thanks,
~Jas

On 8/16/06, Jasbinder Bali <jsbali(at)gmail(dot)com> wrote:
>
> I did commit the transaction by writing
> EXEC SQL COMMIT; right after the insert statement.
>
> Then also its not inserting the record and says:
> [2998]: ECPGexecute line 97 Ok: INSERT 0 1
> and SQLCODE is still 0
>
> ~Jas
>
> On 8/1/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> > On Wed, Aug 16, 2006 at 01:46:30AM -0400, Jasbinder Bali wrote:
> > > I changed the datatype from varchar[] to varchar
> > > ECPGdebug(1,stderr) says
> > > [2998]: ECPGexecute line 97 Ok: INSERT 0 1
> > >
> > > Its not inserting any record even though sqlcode is 0.
> >
> > Are you committing the transaction? See the bottom of the
> > following page:
> >
> > http://www.postgresql.org/docs/8.1/interactive/ecpg-commands.html
> >
> > "In the default mode, statements are committed only when EXEC SQL
> > COMMIT is issued."
> >
> > --
> > Michael Fuhr
> >
>
>