Entered data appears TWICE in table!!?

From: rmorgan7(at)austin(dot)rr(dot)com (Ron M(dot))
To: pgsql-sql(at)postgresql(dot)org
Subject: Entered data appears TWICE in table!!?
Date: 2004-03-30 19:29:06
Message-ID: d7fc3008.0403301129.22a499c9@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2004-03-30 22:08:08 plpgsql vs. SQL in stored procedures
Previous Message Josh Berkus 2004-03-29 21:47:43 Re: Slow sub-selects, max and count(*)