Re: Re: what means "INSERT xxx yyy" ? - Mailing list pgsql-admin

From Kajetan Kazimierczak
Subject Re: Re: what means "INSERT xxx yyy" ?
Date
Msg-id 3A954208.F9ACFC4E@wineasy.se
Whole thread Raw
In response to Re: what means "INSERT xxx yyy" ?  ("mike" <matrix@quadrent.net>)
List pgsql-admin

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.


pgsql-admin by date:

Previous
From: Dave Mertens
Date:
Subject: Re: [HACKERS] Re: v7.1b4 bad performance
Next
From: Stephan Szabo
Date:
Subject: Re: relation does not exist