Re: [SQL] PRIMARY KEY and INDEX

2004-09-02 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 2 Sep 2004, Nosyman wrote: It is necessary to define an index for a primary key column? Let's have an example CREATE TABLE users( id_user INTEGER PRIMARY KEY, user_name VARCHAR(25) ); Does PgSQL automatically create an index for id_user (pri

Re: [SQL] PRIMARY KEY and INDEX

2004-09-02 Thread Achilleus Mantzios
O kyrios Nosyman egrapse stis Sep 2, 2004 : > It is necessary to define an index for a primary key column? > > Let's have an example > CREATE TABLE users( > id_user INTEGER PRIMARY KEY, > user_name VARCHAR(25) > ); > > Does PgSQL automatically create an index for id_user (primary key) or it > mu

[SQL] PRIMARY KEY and INDEX

2004-09-02 Thread Nosyman
It is necessary to define an index for a primary key column? Let's have an example CREATE TABLE users( id_user INTEGER PRIMARY KEY, user_name VARCHAR(25) ); Does PgSQL automatically create an index for id_user (primary key) or it must be created by hand? Thanks