Skip site navigation (1) Skip section navigation (2)

Re: Re: what means "INSERT xxx yyy" ?

From: Kajetan Kazimierczak <kajetan(at)wineasy(dot)se>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: what means "INSERT xxx yyy" ?
Date: 2001-02-22 16:44:56
Message-ID: 3A954208.F9ACFC4E@wineasy.se (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-sql

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.


In response to

pgsql-sql by date

Next:From: J.H.M. Dassen RayDate: 2001-02-22 17:11:37
Subject: Re: two tables - foreign keys referring to each other...]
Previous:From: Richard HuxtonDate: 2001-02-22 14:29:35
Subject: Re: problem with dates

pgsql-admin by date

Next:From: Adam RoseDate: 2001-02-23 01:00:59
Subject: Column character length
Previous:From: Nicholas MudieDate: 2001-02-22 16:42:20
Subject: TRIGGER HELP in oracle

pgsql-general by date

Next:From: Renaud TthonnartDate: 2001-02-22 16:45:17
Subject: Re: Query with multiples operators BETWEEN
Previous:From: Peter EisentrautDate: 2001-02-22 16:39:06
Subject: Re: Errors in other languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group