Re: [NOVICE] DB insert Error

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jasbinder Bali <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] DB insert Error
Date: 2006-08-17 20:07:13
Message-ID: 20060817200713.GA92094@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jasbinder Bali 2006-08-18 01:19:37 Re: [NOVICE] DB insert Error
Previous Message Mike Nees 2006-08-17 19:45:15 Re: COPY command

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-08-17 20:07:30 Re: Best approach for a "gap-less" sequence
Previous Message Brad Nicholson 2006-08-17 19:36:29 Re: Best approach for a "gap-less" sequence