Re: [NOVICE] DB insert Error

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 <mike(at)fuhr(dot)org> wrote:
>
> 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 the right schema?
>
> Here's a complete example for you to try:
>
> 1. Create the following table:
>
> CREATE TABLE public.foo (
> id integer PRIMARY KEY,
> msg text NOT NULL
> );
>
> 2. Compile the following program:
>
> int main(void)
> {
> EXEC SQL BEGIN DECLARE SECTION;
> char msg[] = "This is a test.";
> EXEC SQL END DECLARE SECTION;
>
> ECPGdebug(1, stderr);
>
> /* Adjust the next line as necessary. */
> EXEC SQL CONNECT TO tcp:postgresql://192.168.0.110/xyz USER jsbali;
> EXEC SQL INSERT INTO public.foo (id, msg) VALUES (1, :msg);
> EXEC SQL COMMIT;
> EXEC SQL DISCONNECT;
>
> return 0;
> }
>
> 3. Run the above program and post all output it generates.
>
> 4. Connect to the database with psql or whatever client you use,
> execute the following query, and post the output:
>
> SELECT * FROM public.foo;
>
> Also, what version of PostgreSQL are you using and what platforms
> are the server and client? I don't recall if you've said.
>
> --
> Michael Fuhr
>