Thread

1. primary key attribute

   Joao Paulo Felix <felix@cyclades.com> — 1998-05-29T18:29:24Z

   Hi there,
   
   I am having trouble trying to alter a class and update an column
   constraint to PRIMARY KEY. I decided to create a new table using the
   following, still it does seem work:
   
   CREATE TABLE my_table
   
   	(my_column INT PRIMARY KEY, my_column2 TEXT);
   
   Could any one help me please. Thanks in advance.
   
   Joao Paulo
   
   

2. Re: [GENERAL] primary key attribute

   Billy Donahue <donahu@cooper.edu> — 1998-05-29T21:37:14Z

   Joao Paulo Felix wrote:
   > 
   > Hi there,
   > 
   > I am having trouble trying to alter a class and update an column
   > constraint to PRIMARY KEY. I decided to create a new table using the
   > following, still it does seem work:
   > 
   > CREATE TABLE my_table
   > 
   >         (my_column INT PRIMARY KEY, my_column2 TEXT);
   > 
   > Could any one help me please. Thanks in advance.
   > 
   > Joao Paulo
   
   I'm new to this myself, but I know there's no 
   PRIMARY KEY in the SQL subset supported by PostgreSQL.
   
   You can get the same effect by
   CREATE TABLE my_table (my_column INT, my_column2 TEXT);
   
   CREATE UNIQUE INDEX my_table_my_column_key 
   	ON my_table(my_column);
   
   Then you'll be guaranteed that all records will have 
   distinct my_column integers.  Hope this helps.