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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
