X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CD3A756479 for ; Tue, 1 Mar 2005 15:43:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88963-02 for ; Tue, 1 Mar 2005 15:43:18 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 378AC5646A for ; Tue, 1 Mar 2005 15:43:15 +0000 (GMT) Received: (qmail 23890 invoked from network); 1 Mar 2005 15:46:06 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 1 Mar 2005 15:46:06 -0000 Received: from webmail.moph.go.th ([127.0.0.1]) by localhost (webmail.moph.go.th [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 22439-39 for ; Tue, 1 Mar 2005 22:46:04 +0700 (ICT) Received: (qmail 23880 invoked from network); 1 Mar 2005 15:46:02 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 1 Mar 2005 15:46:02 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 1 Mar 2005 22:46:02 +0700 Message-ID: <1109691962.42248e3a3c898@webmail.moph.go.th> Date: Tue, 1 Mar 2005 22:46:02 +0700 From: amrit@health2.moph.go.th To: PGsql-performance Subject: What is the postgres sql command for last_user_id ??? MIME-Version: 1.0 Content-Type: text/plain; charset=TIS-620 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 203.157.100.42 X-Virus-Scanned: by amavisd-new at moph.go.th X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200503/21 X-Sequence-Number: 10726 I would like to know whether there is any command which the server will give the record ID back to the client when client puts the data and the server generates an autoincrement ID for that record. For example if many clients try to put the money data to the server and each record from each client has its own record ID by autoincrement process of the server [x+1] and i don't need to lock the record since it will bring the system to slow down. That client wil then want to know which ID that server gives to that record in order to select that record to print the reciept [bill]. I know that in mysql there is a command "last_record_id" which acts the same as I mention above. Does anybody know that , please give me the detail? Amrit,Thailand