pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PostgreSQL Admin <postgres@Mythos.Org>
To: pgsql-interfaces@postgreSQL.org
Subject: Serial Auto Increment
Date: Mon, 26 Apr 1999 19:02:32 -0400 (EDT)
Message-ID: <199904262302.TAA30762@Mythos.Org> (raw)

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



Message-ID: <199904262302.TAA30762@Mythos.Org>
Permalink:  ../199904262302.TAA30762@Mythos.Org/
Also on:    postgresql.org/message-id/199904262302.TAA30762@Mythos.Org

 · 

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-interfaces@postgresql.org
  Cc: postgres@Mythos.Org
  Subject: Re: Serial Auto Increment
  In-Reply-To: <199904262302.TAA30762@Mythos.Org>

* 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