| From: | "mike" <matrix(at)quadrent(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, "Jean-Arthur Silve" <jeanarthur(at)eurovox(dot)fr> |
| Subject: | Re: what means "INSERT xxx yyy" ? |
| Date: | 2001-02-15 16:18:08 |
| Message-ID: | 000d01c0976a$e2b16ce0$c4a35bd1@neutrino |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-sql |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.H.M. Dassen Ray | 2001-02-15 16:31:31 | Re: what means "INSERT xxx yyy" ? |
| Previous Message | Tom Lane | 2001-02-15 15:30:20 | Re: LockReplace: xid table corrupted |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-02-15 16:18:54 | Re: regular expression substittion function? |
| Previous Message | David Wheeler | 2001-02-15 16:15:51 | Re: regular expression substittion function? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-02-15 16:30:07 | Re: problem with casting |
| Previous Message | Mark Byerley | 2001-02-15 15:31:52 | Datetime Query |