Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 6F52C2E004C
	for <pgsql-interfaces-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 14:53:39 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 70528-04
	for <pgsql-interfaces-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 14:53:33 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.249])
	by developer.postgresql.org (Postfix) with ESMTP id 429102E0048
	for <pgsql-interfaces@postgresql.org>;
	Fri, 13 Jun 2008 14:53:34 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id d30so949455and.33
	for <pgsql-interfaces@postgresql.org>;
	Fri, 13 Jun 2008 10:53:33 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:sender
	:to:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references
	:x-google-sender-auth;
	bh=+YP9Apgt+FLnGUImFJCVP1sqrR5a2Wh1K2FReYKwkyg=;
	b=eagwkkipyU/yDFpL9DRkZ+IetdOAbAoNPy0cemaFu0E/929tf2T7Z0v0b/Du3Wdbb+
	Wg677Sj7gAZhxyqtINTbaW5dnP3aCDp3JCDbHJjyKzKchAPJmBxlcP+cQWuSxmGL/w9Y
	l7Dq6UNILKouob5DJLqpn5cgcu1xSSVoakhfs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references:x-google-sender-auth;
	b=rmFC3/x6lpXeJ6l4L8VmQh0ZIA5xEm4MT9g5bS/mOX/TOYvGK2UhEVr0MHzuTvudY+
	wI+QBB0QTKF/kLdrQtcgH9Jswi1g0kIO2FUckroAFuOpPsBySvbK7a4XMVLk/hsXXCOl
	o/PTjqW1aPw305EZ/EGruDxg0o4TuEz85A7GE=
Received: by 10.100.128.20 with SMTP id a20mr4616096and.153.1213379613764;
	Fri, 13 Jun 2008 10:53:33 -0700 (PDT)
Received: by 10.100.197.2 with HTTP; Fri, 13 Jun 2008 10:53:33 -0700 (PDT)
Message-ID: <264855a00806131053r36768162mde26a0615b5ca00d@mail.gmail.com>
Date: Fri, 13 Jun 2008 13:53:33 -0400
From: "Sean Davis" <sdavis2@mail.nih.gov>
To: "Premil Agarwal" <preagarw@gmail.com>
Subject: Re: GenGUID (AutoNumber) in postgres
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <92aa956e0806131048g6c70ecf1xb558c29af7c523ce@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <92aa956e0806131048g6c70ecf1xb558c29af7c523ce@mail.gmail.com>
X-Google-Sender-Auth: 5b42dfe61fce9ea0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/15
X-Sequence-Number: 6758

On Fri, Jun 13, 2008 at 1:48 PM, Premil Agarwal <preagarw@gmail.com> wrote:
> I have a database that was migrated from Access. I am having trouble porting
> "AutoNumber" datatype. The column that is of type "AutoNumber" is suppose to
> Unique ID (PK) for that table. Internally it uses GenGUID API in access to
> generate the unique ID.
>
> Any ideas on how to port this functionality to Postgres.

I don't use Access, but you might want to look at the documentation
about "serial" data type.

Sean