From: Michael Fuhr <mike@fuhr.org>
To: Mian Yong Leow <myleow@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Insert successful but data not found
Date: Sun, 12 Dec 2004 19:12:11 -0700
Message-ID: <20041213021211.GA67661@winnie.fuhr.org> (raw)
In-Reply-To: <20041207025843.30375.qmail@web41523.mail.yahoo.com>
References: <20041207025843.30375.qmail@web41523.mail.yahoo.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, myleow@yahoo.com
Subject: Re: Insert successful but data not found
In-Reply-To: <20041213021211.GA67661@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox