From: rmorgan7@austin.rr.com
To: pgsql-sql@postgresql.org
Subject: Entered data appears TWICE in table!!?
Date: 30 Mar 2004 11:29:06 -0800
Message-ID: <d7fc3008.0403301129.22a499c9@posting.google.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmorgan7@austin.rr.com
Subject: Re: Entered data appears TWICE in table!!?
In-Reply-To: <d7fc3008.0403301129.22a499c9@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox