| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Rose | 2001-02-23 01:00:59 | Column character length |
| Previous Message | Nicholas Mudie | 2001-02-22 16:42:20 | TRIGGER HELP in oracle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Renaud Tthonnart | 2001-02-22 16:45:17 | Re: Query with multiples operators BETWEEN |
| Previous Message | Peter Eisentraut | 2001-02-22 16:39:06 | Re: Errors in other languages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.H.M. Dassen Ray | 2001-02-22 17:11:37 | Re: two tables - foreign keys referring to each other...] |
| Previous Message | Richard Huxton | 2001-02-22 14:29:35 | Re: problem with dates |