X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37E263A60DB for ; Tue, 7 Dec 2004 02:58:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79580-10 for ; Tue, 7 Dec 2004 02:58:41 +0000 (GMT) Received: from web41523.mail.yahoo.com (web41523.mail.yahoo.com [66.218.94.130]) by svr1.postgresql.org (Postfix) with SMTP id C57253A60FA for ; Tue, 7 Dec 2004 02:58:43 +0000 (GMT) Received: (qmail 30377 invoked by uid 60001); 7 Dec 2004 02:58:43 -0000 Message-ID: <20041207025843.30375.qmail@web41523.mail.yahoo.com> Received: from [63.205.67.145] by web41523.mail.yahoo.com via HTTP; Mon, 06 Dec 2004 18:58:43 PST Date: Mon, 6 Dec 2004 18:58:43 -0800 (PST) From: Mian Yong Leow Subject: Insert successful but data not found To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/69 X-Sequence-Number: 19689 Has anyone encountered this problem before? 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. This is just a simple table with (Integer, Varchar(25),Varchar(50),Varchar(50)) type of data. The error does not occur all the time, it only happens once in a while. Would appreciate if anyone can share their experience and ways of getting around it with me. Thank you in advance. Mian __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail