X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 33179D1D12E for ; Mon, 5 Apr 2004 22:32:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10419-10 for ; Mon, 5 Apr 2004 19:32:57 -0300 (ADT) Received: from web20806.mail.yahoo.com (web20806.mail.yahoo.com [216.136.226.195]) by svr1.postgresql.org (Postfix) with SMTP id E5BB5D1D16D for ; Mon, 5 Apr 2004 19:32:23 -0300 (ADT) Message-ID: <20040405223302.58808.qmail@web20806.mail.yahoo.com> Received: from [24.248.12.72] by web20806.mail.yahoo.com via HTTP; Mon, 05 Apr 2004 15:33:02 PDT Date: Mon, 5 Apr 2004 15:33:02 -0700 (PDT) From: Jeff Eckermann Subject: Re: Entered data appears TWICE in table!!? To: "Ron M." , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/30 X-Sequence-Number: 17405 What interface are you using? --- "Ron M." wrote: > I'm JUST getting started with the online SQL > tutorial at > http://sqlcourse.com. When I create a table and > insert data, the data > appears TWICE. A simple example: > > ***Create the table: > > create table rnmrgntable > (first varchar(20), > last varchar(30)); > > ***Insert data: > > insert into rnmrgntable > (first, last) > values ('Bill' , 'Smith'); > > ***Then look at the table: > > select * from rnmrgntable; > > And I get: > > first last > Bill Smith > Bill Smith > > EVERYTHING I enter appears twice, duplicated on two > rows as in this > example. What the heck's going on? > > Ron M. > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/