Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA92228 for ; Wed, 24 May 2000 15:33:58 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id PAA31534 for pgsql-sql@postgresql.org; Wed, 24 May 2000 15:33:39 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f From: Kees Kuip X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Automatic index numbers Date: Wed, 24 May 2000 19:38:26 +0000 Organization: XS4ALL Internet BV Lines: 12 Message-ID: <392C2FB2.FBF1C325@technologist.com> References: <39233EE0.D7618BB2@clacknet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news1.xs4all.nl 959196814 21667 194.109.138.204 (24 May 2000 19:33:34 GMT) X-Complaints-To: abuse@xs4all.nl X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200005/122 Daniel Mendyke wrote: > > How can I automatically create a unique index > number when I add new data to a table? > Try CREATE TABLE test ( id serial )