| 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-16 05:54:19 |
| Message-ID: | 20060816055419.GA51092@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harpreet Dhaliwal | 2006-08-16 06:25:13 | Re: Trigger (Calling a Procedure) |
| Previous Message | Michael Fuhr | 2006-08-16 05:50:55 | Re: Trigger (Calling a Procedure) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Rasmussen | 2006-08-16 06:26:21 | Optimal Postgres Development Process, Software |
| Previous Message | Jasbinder Bali | 2006-08-16 05:49:25 | Re: DB insert Error |