Re: [NOVICE] DB insert Error

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/ function.

Harpreet

On 8/16/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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>