Skip site navigation (1) Skip section navigation (2)

BUG #2468: how to create auto-generate primary key

From: "vivekananda" <r(dot)vivekanandaswamy(at)rediffmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2468: how to create auto-generate primary key
Date: 2006-06-05 06:33:31
Message-ID: 200606050633.k556XVMj097544@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2468
Logged by:          vivekananda
Email address:      r(dot)vivekanandaswamy(at)rediffmail(dot)com
PostgreSQL version: 8.1
Operating system:   Windows-2000
Description:        how to create auto-generate primary key
Details: 

Hi,
Good morning all.How to create automatic generated key while creating table
like OID's.is there any posibility to create this one?

for example create table emp(no numaric(3),name varchar(10))

here there is no primary key explicitly.But i want use primary key with
adding 3rd column for generating querys.

OID's are uniqe for all tables.but i want impliment this feature only for
specified table.How?

Responses

pgsql-bugs by date

Next:From: samirDate: 2006-06-05 09:17:30
Subject: BUG #2469: Error in connection to the server
Previous:From: Rae StieningDate: 2006-06-04 17:45:35
Subject: BUG #2467: Documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group