From: | greg(at)proterians(dot)net |
---|---|
To: | Chairudin Sentosa Harjo <chai(at)prima(dot)net(dot)id> |
Cc: | Simon Drabble <simon(at)eskimo(dot)com>, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] insert explanation |
Date: | 1999-10-14 09:56:32 |
Message-ID: | Pine.LNX.4.05.9910141155180.13369-100000@proterians.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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--
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 1999-10-14 11:18:29 | Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgresuser's password? |
Previous Message | greg | 1999-10-14 09:54:00 | Re: [GENERAL] insert explanation |