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 07BFFD1D58C for ; Tue, 30 Mar 2004 19:50:38 +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 56821-09 for ; Tue, 30 Mar 2004 15:50:37 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3EEF7D1E914 for ; Tue, 30 Mar 2004 15:50:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2UJoZYn041806 for ; Tue, 30 Mar 2004 19:50:35 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2UJT6pH037490 for pgsql-sql@postgresql.org; Tue, 30 Mar 2004 19:29:06 GMT From: rmorgan7@austin.rr.com (Ron M.) X-Newsgroups: comp.databases.postgresql.sql Subject: Entered data appears TWICE in table!!? Date: 30 Mar 2004 11:29:06 -0800 Organization: http://groups.google.com Lines: 30 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/16 X-Sequence-Number: 17391 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.