My program started working.
Its inserting records now.
I've done no significant changes in my C code.
Thanks alot for your help.
Jasbinder
On 8/17/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Aug 17, 2006 at 10:19:57AM -0400, Jasbinder Bali wrote:> but i don't see any record getting inser
On Thu, Aug 17, 2006 at 10:19:57AM -0400, Jasbinder Bali wrote:
> but i don't see any record getting inserted in the table..
> Why is that happenening.
How exactly are you determining that the record isn't being inserted?
Are you sure you're connected to the right database and querying
tables in t
but i don't see any record getting inserted in the table..Why is that happenening.On 8/17/06, Michael Meskes <
[EMAIL PROTECTED]> wrote:On Wed, Aug 16, 2006 at 11:40:40AM -0400, Jasbinder Bali wrote:
> [2998]: ECPGexecute line 97 Ok: INSERT 0 1This is a backend message saying that the insert comman
On Wed, Aug 16, 2006 at 11:40:40AM -0400, Jasbinder Bali wrote:
> [2998]: ECPGexecute line 97 Ok: INSERT 0 1
This is a backend message saying that the insert command was executed error
free and inserted one record.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meske
Also, I think you should check the special characters in the text that you
are trying to store.
I realize from one of your emails that when u run the same query using the PGAdmin query tool, only a part
of the the varchar gets stores and rest it trimmed.
This has something to do with the specia
On Wed, Aug 16, 2006 at 04:11:23PM -0400, Jasbinder Bali wrote:
> I'm sending u the main() function that has the ECPG Insert statement and
> commit in it.
The program you posted isn't a simplified example as I requested.
The idea is that anybody should be able to compile the code and run
it; that'
This is the create table statement..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;
ALTER TABLE raw_email OWNER TO postgres;On 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Wed, Au
I'm sending u the main() function that has the ECPG Insert statement and commit in it.---START---#include <
stdio.h>#include #include #include
EXEC SQL INCLUDE sqlca;
#define MP 10#define MSG_LEN 102400
On Wed, Aug 16, 2006 at 02:42:46PM -0400, Jasbinder Bali wrote:
> Tried everthing but nothing seems to work.
> :(
Could you provide a simplified but complete example that shows what
you're doing? That is, all SQL statements and C code necessary to
create a table and whatever functions you're usin
Tried everthing but nothing seems to work.:(On 8/16/06, Jasbinder Bali <[EMAIL PROTECTED]> wrote:
Also, i tried to mannualy run the insert query in the query tool
insert into raw_email ( id , raw_email ) values ( 1 , 'From
[EMAIL PROTE
Harpreet Dhaliwal wrote:
> Forgot to write that that was my question.
> I mean can we call a stored procedure as an action of a trigger?
Sure, here's a working example from a running application:
CREATE OR REPLACE FUNCTION assign_detail_device_type_seq() RETURNS
trigger AS $$
BEGIN
IF
On Wed, Aug 16, 2006 at 02:59:23AM -0400, Harpreet Dhaliwal wrote:
> I mean can we call a stored procedure as an action of a trigger?
You'll need to write a trigger function that calls the non-trigger
function (what you're referring to as "stored procedure"). Example:
CREATE FUNCTION trigger_fun
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 1and SQLCODE is still 0
~JasOn 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Wed, Aug 16, 2006 at 01:46:30AM -0400
Also, i tried to mannualy run the insert query in the query toolinsert into raw_email ( id , raw_email ) values ( 1 , 'From
[EMAIL PROTECTED] Tue Apr 15 20:24:47 2003X-MultiHeader: oneX-MultiHeader: twoX-MultiHeader: threeFrom: Simon C
Forgot to write that that was my question.
I mean can we call a stored procedure as an action of a trigger?
On 8/16/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
Its actually something like the trigger should start a C function after insert and the C function has the ECPG code for some more i
Its actually something like the trigger should start a C function after insert and the C function has the ECPG code for some more inserts.
Its similar to the way we dynamically load a shared library while executing a stored procedure, as in , executing a fucntion in C file using stored procedure/ f
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
17 matches
Mail list logo