Postgres Pro
Downloads
Home   >   mailing lists

Thread: insert explanation

insert explanation

From
Chairudin Sentosa Harjo
Date:
Dear all,

mydb=> create table rtext (rtext varchar(10));
CREATE
mydb=> insert into rtext values ('hello');
INSERT 17681 1

What do "17681" and "1" mean?

Could someone help me to understand this please?

Regards,
Chai

Re: [GENERAL] insert explanation

From
Simon Drabble
Date:
On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:

> Dear all,
>
> mydb=> create table rtext (rtext varchar(10));
> CREATE
> mydb=> insert into rtext values ('hello');
> INSERT 17681 1
>
> What do "17681" and "1" mean?
>
> Could someone help me to understand this please?
>
> Regards,
> Chai


17681: oid (object ID) of the inserted row
1: number of rows inserted.


Simon.


--
 "Linux - open doors, not windows."

   Simon Drabble                      It's like karma for your brain.
   simon@eskimo.com

Re: [GENERAL] insert explanation

From
Chairudin Sentosa Harjo
Date:
Simon Drabble wrote:
>
> On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
>
> > Dear all,
> >
> > mydb=> create table rtext (rtext varchar(10));
> > CREATE
> > mydb=> insert into rtext values ('hello');
> > INSERT 17681 1
> >
> > What do "17681" and "1" mean?
> >
> > Could someone help me to understand this please?
> >
> > Regards,
> > Chai
>
> 17681: oid (object ID) of the inserted row
> 1: number of rows inserted.
>


Why does it start from 17681?
This is a fresh new table, shouldn't it start from 1?

Regards,
Chai

Re: [GENERAL] insert explanation

From
greg@proterians.net
Date:


On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:

> Dear all,
>
> mydb=> create table rtext (rtext varchar(10));
> CREATE
> mydb=> insert into rtext values ('hello');
> INSERT 17681 1
>
> What do "17681" and "1" mean?
>
> Could someone help me to understand this please?
>


  "17681": number written into oid field into table rtext...
  "1": 'one' record was saved...

Re: [GENERAL] insert explanation

From
greg@proterians.net
Date:


On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:

> Simon Drabble wrote:
> >
> > On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> >
> > > Dear all,
> > >
> > > mydb=> create table rtext (rtext varchar(10));
> > > CREATE
> > > mydb=> insert into rtext values ('hello');
> > > INSERT 17681 1
> > >
> > > What do "17681" and "1" mean?
> > >
> > > Could someone help me to understand this please?
> > >
> > > Regards,
> > > Chai
> >
> > 17681: oid (object ID) of the inserted row
> > 1: number of rows inserted.
> >
>
>
> Why does it start from 17681?
> This is a fresh new table, shouldn't it start from 1?
>

   Because another records in pg_... tables have a oid numbers...

  --Greg--