Received: from Mythos.Org (IDENT:postgres@clt93-008.carolina.rr.com
	[24.93.93.8]) by hub.org (8.9.3/8.9.1) with ESMTP id QAA76201
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 26 Apr 1999 16:56:49 -0400 (EDT)
	(envelope-from postgres@Mythos.Org)
Received: (from postgres@localhost) by Mythos.Org (8.8.7/8.8.7) id TAA30762
	for pgsql-interfaces@postgreSQL.org; Mon, 26 Apr 1999 19:02:32 -0400
From: PostgreSQL Admin <postgres@Mythos.Org>
Message-Id: <199904262302.TAA30762@Mythos.Org>
Subject: Serial Auto Increment
To: pgsql-interfaces@postgreSQL.org
Date: Mon, 26 Apr 1999 19:02:32 -0400 (EDT)
Content-Type: text

Let me give a simple example of what I am trying to do:

CREATE SEQUENCE "usernumber" start 0 increment 1;

Create table users (
	name	varchar(255),
	userid	int4 DEFAULT nextval ( 'usernumber' ) NOT NULL);
);

From Borland C++ Builder I create a form with a 
link to the table userid and a navigator bar and a DBedit object linked
to the field userid.

When I post new record, an error is returned that users.name cannot be
null, which is true.  Is there a way to make Borland C++ Builder only
update the field "name" and let Postgresql take care of the
updating the serial field "userid"

Thanks,
	Travis