Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id BB4852E004C
	for <pgsql-interfaces-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 14:48:53 -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 66188-02
	for <pgsql-interfaces-postgresql.org@developer.postgresql.org>;
	Fri, 13 Jun 2008 14:48:49 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.30])
	by developer.postgresql.org (Postfix) with ESMTP id DE3DC2E0048
	for <pgsql-interfaces@postgresql.org>;
	Fri, 13 Jun 2008 14:48:50 -0300 (ADT)
Received: by yw-out-2324.google.com with SMTP id 3so2362364ywj.73
	for <pgsql-interfaces@postgresql.org>;
	Fri, 13 Jun 2008 10:48:46 -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:to
	:subject:mime-version:content-type;
	bh=E0ZhqhHnhvipDOkR5SZlBgHpSsb2xQCJzvhm7VSKUl8=;
	b=YQnSOTA2JBO1/BfLIzyWBRoft2RMOaeypRJY8lJ/RyjL7JwV0fqEx7I51Zc1yj6/jv
	YzAXG0OgOG3gNl0RYNHO5vtiKiHMVt2VrsC3qLW3WW4LLrd5jJDFJ6aj50QtqfLOzukJ
	cGIhVQz8o7wuJCWXD0omQBMPTOBVyLcq05jaU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=sOny0pLlhxTf8lcddDijIiAsqSRSoKruce6YZ4BYbz+RgUFViqR6PXwNFJ762U0cTR
	jyjbQL7tOH+qAHH4QxIzKheAe1Qbv4lHNb4vioVOTe7nwLylspkj52/keeCAem0tyrtg
	/n0EAe9ArzmGjP95uDT3GjZOhxW5j3XQHYtv0=
Received: by 10.150.58.17 with SMTP id g17mr1516007yba.219.1213379325956;
	Fri, 13 Jun 2008 10:48:45 -0700 (PDT)
Received: by 10.150.200.17 with HTTP; Fri, 13 Jun 2008 10:48:45 -0700 (PDT)
Message-ID: <92aa956e0806131048g6c70ecf1xb558c29af7c523ce@mail.gmail.com>
Date: Fri, 13 Jun 2008 13:48:45 -0400
From: "Premil Agarwal" <preagarw@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: GenGUID (AutoNumber) in postgres
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2921_32506831.1213379325914"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200806/14
X-Sequence-Number: 6757

------=_Part_2921_32506831.1213379325914
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

Thanks

------=_Part_2921_32506831.1213379325914
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have a database that was migrated from Access. I am having trouble porting &quot;AutoNumber&quot; datatype. The column that is of type &quot;AutoNumber&quot; is suppose to Unique ID (PK) for that table. Internally it uses GenGUID API in access to generate the unique ID.<br>
<br>Any ideas on how to port this functionality to Postgres. <br><br>Thanks<br><br><br><br>

------=_Part_2921_32506831.1213379325914--