Re: [GENERAL] insert explanation

Поиск
Список
Период
Сортировка
От greg@proterians.net
Тема Re: [GENERAL] insert explanation
Дата
Msg-id Pine.LNX.4.05.9910141155180.13369-100000@proterians.net
обсуждение исходный текст
Ответ на Re: [GENERAL] insert explanation  (Chairudin Sentosa Harjo <chai@prima.net.id>)
Список 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--


В списке pgsql-general по дате отправления:

Предыдущее
От: greg@proterians.net
Дата:
Сообщение: Re: [GENERAL] insert explanation
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgresuser's password?