pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedEntered data appears TWICE in table!!?
3+ messages / 2 participants
[nested] [flat]
* Entered data appears TWICE in table!!?
@ 2004-03-30 19:29 Ron M. <rmorgan7@austin.rr.com>
2004-04-05 22:33 ` Re: Entered data appears TWICE in table!!? Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: rmorgan7@austin.rr.com @ 2004-03-30 19:29 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Entered data appears TWICE in table!!?
2004-03-30 19:29 Entered data appears TWICE in table!!? Ron M. <rmorgan7@austin.rr.com>
@ 2004-04-05 22:33 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jeff Eckermann @ 2004-04-05 22:33 UTC (permalink / raw)
To: Ron M. <rmorgan7@austin.rr.com>; 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Entered data appears TWICE in table!!?
@ 2004-04-06 14:27 Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jeff Eckermann @ 2004-04-06 14:27 UTC (permalink / raw)
To: Ron Morgan <rmorgan7@austin.rr.com>; +Cc: pgsql-sql
--- Ron Morgan <rmorgan7@austin.rr.com> wrote:
> Both Internet Explorer and Safari, on a Mac running
> OS X.
>
> I'm just using the tutorial web site at
> sqlcourse.com. They have a window
> there where you type code and run it, etc.
>
> Ron
>
I recall doing that tutorial once upon a time. A very
good thing.
But I don't see the connection to PostgreSQL. Perhaps
you can explain it?
> ----- Original Message -----
> From: "Jeff Eckermann" <jeff_eckermann@yahoo.com>
> To: "Ron M." <rmorgan7@austin.rr.com>;
> <pgsql-sql@postgresql.org>
> Sent: Monday, April 05, 2004 5:33 PM
> Subject: Re: [SQL] Entered data appears TWICE in
> table!!?
>
>
> > 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/
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system
> (http://www.grisoft.com).
> Version: 6.0.644 / Virus Database: 412 - Release
> Date: 3/26/2004
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-04-06 14:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-30 19:29 Entered data appears TWICE in table!!? Ron M. <rmorgan7@austin.rr.com>
2004-04-05 22:33 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
2004-04-06 14:27 Re: Entered data appears TWICE in table!!? Jeff Eckermann <jeff_eckermann@yahoo.com>
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