Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1O4Jxx48414 for ; Fri, 23 Feb 2001 23:19:59 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MH1Sx67785 for ; Thu, 22 Feb 2001 12:01:28 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f1MGojD22920 for pgsql-admin@postgresql.org; Thu, 22 Feb 2001 11:50:46 -0500 (EST) (envelope-from news) From: Kajetan Kazimierczak X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Re: what means "INSERT xxx yyy" ? Date: Thu, 22 Feb 2001 17:44:56 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 29 Message-ID: <3A954208.F9ACFC4E@wineasy.se> References: <000d01c0976a$e2b16ce0$c4a35bd1@neutrino> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.7 [en] (Win98; I) X-Accept-Language: en To: pgsql-admin@postgresql.org X-Archive-Number: 200102/200 X-Sequence-Number: 807 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.