Re: Entered data appears TWICE in table!!? - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: Entered data appears TWICE in table!!?
Date
Msg-id 20040405223302.58808.qmail@web20806.mail.yahoo.com
Whole thread Raw
In response to Entered data appears TWICE in table!!?  (rmorgan7@austin.rr.com (Ron M.))
List pgsql-sql
What interface are you using?

--- "Ron M." <rmorgan7@austin.rr.com> 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/


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: group by not returning sorted rows
Next
From: "kumar"
Date:
Subject: Rename Schema or Script DDL only a schema