pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat 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>
2001-02-15 12:56 ` Re: [GENERAL] what means "INSERT xxx yyy" ? Richard Huxton <dev@archonet.com>
2001-02-15 16:18 ` Re: what means "INSERT xxx yyy" ? mike <matrix@quadrent.net>
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 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 ` Re: Re: [GENERAL] what means "INSERT xxx yyy" ? Jie Liang <jliang@ipinc.com>
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: Re: [GENERAL] what means "INSERT xxx yyy" ?
2001-02-15 09:10 what means "INSERT xxx yyy" ? Jean-Arthur Silve <jeanarthur@eurovox.fr>
2001-02-15 12:56 ` Re: [GENERAL] what means "INSERT xxx yyy" ? Richard Huxton <dev@archonet.com>
@ 2001-02-16 21:50 ` Jie Liang <jliang@ipinc.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: what means "INSERT xxx yyy" ?
2001-02-15 09:10 what means "INSERT xxx yyy" ? Jean-Arthur Silve <jeanarthur@eurovox.fr>
@ 2001-02-15 16:18 ` mike <matrix@quadrent.net>
2001-02-15 16:31 ` Re: what means "INSERT xxx yyy" ? J.H.M. Dassen (Ray) <jdassen@cistron.nl>
2001-02-22 16:44 ` Re: Re: what means "INSERT xxx yyy" ? Kajetan Kazimierczak <kajetan@wineasy.se>
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 09:10 what means "INSERT xxx yyy" ? Jean-Arthur Silve <jeanarthur@eurovox.fr>
2001-02-15 16:18 ` Re: what means "INSERT xxx yyy" ? mike <matrix@quadrent.net>
@ 2001-02-15 16:31 ` J.H.M. Dassen (Ray) <jdassen@cistron.nl>
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: what means "INSERT xxx yyy" ?
2001-02-15 09:10 what means "INSERT xxx yyy" ? Jean-Arthur Silve <jeanarthur@eurovox.fr>
2001-02-15 16:18 ` Re: what means "INSERT xxx yyy" ? mike <matrix@quadrent.net>
@ 2001-02-22 16:44 ` Kajetan Kazimierczak <kajetan@wineasy.se>
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