Re: Insert successful but data not found

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Mian Yong Leow <myleow(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Insert successful but data not found
Date: 2004-12-13 02:12:11
Message-ID: 20041213021211.GA67661@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Dec 06, 2004 at 06:58:43PM -0800, Mian Yong Leow wrote:

> I perform an INSERTion and there weren't any complains
> of error, so i assume that it has no error. When i
> perform a SELECT there were 0 rows in the table.

What language or program are you using to do the inserts? How are
you checking for errors? Have you done tests to verify that you
*would* see errors if any occurred? Is it possible that the inserting
transaction was rolled back instead of committed?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2004-12-13 02:18:00 Re: parse error at or near "(" -- Huh???
Previous Message Tomas =?iso-8859-1?q?Sk=E4re?= 2004-12-12 08:32:25 Re: [GENERAL] Query is not using index when it should