pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: amrit@health2.moph.go.th
To: PGsql-performance <pgsql-performance@postgresql.org>
Subject: What is the postgres sql command for last_user_id ???
Date: Tue,  1 Mar 2005 22:46:02 +0700
Message-ID: <1109691962.42248e3a3c898@webmail.moph.go.th> (raw)

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





view thread (3+ messages)  latest in thread

Message-ID: <1109691962.42248e3a3c898@webmail.moph.go.th>
Permalink:  ../1109691962.42248e3a3c898@webmail.moph.go.th/
Also on:    postgresql.org/message-id/1109691962.42248e3a3c898@webmail.moph.go.th

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: amrit@health2.moph.go.th
  Subject: Re: What is the postgres sql command for last_user_id ???
  In-Reply-To: <1109691962.42248e3a3c898@webmail.moph.go.th>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox