pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
what means "INSERT xxx yyy" ?
6+ messages / 6 participants
[nested] [flat]

* what means "INSERT xxx yyy" ?
@ 2001-02-15 09:10  Jean-Arthur Silve <jeanarthur@eurovox.fr>
  0 siblings, 2 replies; 6+ messages in thread

From: Jean-Arthur Silve @ 2001-02-15 09:10 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-admin@postgresql.org

Hi !

Does anyone knows what means, after an INSERT for exemple the message :

INSERT 19331808 1

What the meaning of the two numbers ?

I had a problem with a DB because I reached the max transaction ID.

So, how could i know what is the maximum ? and what is the current 
transaction ID ?
Is it the first number ?

Thank you

----------------------------------------------------------------
Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [GENERAL] what means "INSERT xxx yyy" ?
@ 2001-02-15 12:56  Richard Huxton <dev@archonet.com>
  parent: Jean-Arthur Silve <jeanarthur@eurovox.fr>
  1 sibling, 1 reply; 6+ messages in thread

From: Richard Huxton @ 2001-02-15 12:56 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-admin@postgresql.org; Jean-Arthur Silve <jeanarthur@eurovox.fr>

From: "Jean-Arthur Silve" <jeanarthur@eurovox.fr>

> Does anyone knows what means, after an INSERT for exemple the message :
>
> INSERT 19331808 1
>
> What the meaning of the two numbers ?

Sorry - don't know what the first number is - I'm getting 0 here on testing.
The second is the number of rows inserted.

- Richard Huxton




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: what means "INSERT xxx yyy" ?
@ 2001-02-15 16:18  mike <matrix@quadrent.net>
  parent: Jean-Arthur Silve <jeanarthur@eurovox.fr>
  1 sibling, 2 replies; 6+ messages in thread

From: mike @ 2001-02-15 16:18 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-admin@postgresql.org; Jean-Arthur Silve <jeanarthur@eurovox.fr>

> Hi !
>
> Does anyone knows what means, after an INSERT for exemple the message :
>
> INSERT 19331808 1
>
> What the meaning of the two numbers ?
>
> I had a problem with a DB because I reached the max transaction ID.
>
> So, how could i know what is the maximum ? and what is the current
> transaction ID ?
> Is it the first number ?
>
> Thank you

INSERT 19331808 1

That just tells you waht you did "INSERT" and it displays the oid for that
insert "19331808", as for the 1, uncertain waht it is, but its always there

Mike




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: what means "INSERT xxx yyy" ?
@ 2001-02-15 16:31  J.H.M. Dassen (Ray) <jdassen@cistron.nl>
  parent: mike <matrix@quadrent.net>
  1 sibling, 0 replies; 6+ messages in thread

From: jdassen@cistron.nl @ 2001-02-15 16:31 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

mike <matrix@quadrent.net> wrote:
>INSERT 19331808 1
>
>That just tells you waht you did "INSERT" and it displays the oid for that
>insert "19331808", as for the 1, uncertain waht it is

The number of rows affected, IIRC.

HTH,
Ray
-- 
These days we're all supposed to believe that everyone's opinion is equally
valid, but sometimes you just have to stand up and say "Your opinion is
wrong, and here is why, in overwhelming detail."
	http://www.kuro5hin.org/?op=displaystory;sid=2000/10/1/21448/7653




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Re: [GENERAL] what means "INSERT xxx yyy" ?
@ 2001-02-16 21:50  Jie Liang <jliang@ipinc.com>
  parent: Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Jie Liang @ 2001-02-16 21:50 UTC (permalink / raw)
  To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org, Jean-Arthur Silve <jeanarthur@eurovox.fr>

I believe that first number is oid.

Jie LIANG

St. Bernard Software
Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Thu, 15 Feb 2001, Richard Huxton wrote:

> From: "Jean-Arthur Silve" <jeanarthur@eurovox.fr>
> 
> > Does anyone knows what means, after an INSERT for exemple the message :
> >
> > INSERT 19331808 1
> >
> > What the meaning of the two numbers ?
> 
> Sorry - don't know what the first number is - I'm getting 0 here on testing.
> The second is the number of rows inserted.
> 
> - Richard Huxton
> 




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Re: what means "INSERT xxx yyy" ?
@ 2001-02-22 16:44  Kajetan Kazimierczak <kajetan@wineasy.se>
  parent: mike <matrix@quadrent.net>
  1 sibling, 0 replies; 6+ messages in thread

From: Kajetan Kazimierczak @ 2001-02-22 16:44 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org



mike wrote:

> > Hi !
> >
> > Does anyone knows what means, after an INSERT for exemple the message :
> >
> > INSERT 19331808 1
> >
> > What the meaning of the two numbers ?
> >
> > I had a problem with a DB because I reached the max transaction ID.
> >
> > So, how could i know what is the maximum ? and what is the current
> > transaction ID ?
> > Is it the first number ?
> >
> > Thank you
>
> INSERT 19331808 1
>
> That just tells you waht you did "INSERT" and it displays the oid for that
> insert "19331808", as for the 1, uncertain waht it is, but its always there
>
> Mike

The one is the number of records inserted.




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2001-02-22 16:44 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-15 09:10 what means "INSERT xxx yyy" ? Jean-Arthur Silve <jeanarthur@eurovox.fr>
2001-02-15 12:56 ` Richard Huxton <dev@archonet.com>
2001-02-16 21:50   ` Jie Liang <jliang@ipinc.com>
2001-02-15 16:18 ` mike <matrix@quadrent.net>
2001-02-15 16:31   ` J.H.M. Dassen (Ray) <jdassen@cistron.nl>
2001-02-22 16:44   ` Kajetan Kazimierczak <kajetan@wineasy.se>

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