Re: Primary Key - Mailing list pgsql-novice

From Eduardo V. Rodríguez
Subject Re: Primary Key
Date
Msg-id 59B41C14544D314889E6FA384A307A921C90C1@osiris.insys-corp.com.mx
Whole thread Raw
In response to Primary Key  (Eduardo V. Rodríguez <evazquez@insys-corp.com.mx>)
List pgsql-novice
Ok thanks for all the ideas I got it

-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
Sent: Wednesday, June 16, 2004 1:13 PM
To: Eduardo V. Rodríguez
Cc: Postgres (E-mail)
Subject: Re: [NOVICE] Primary Key


On Mon, Jun 14, 2004 at 19:17:37 -0500,
  "Eduardo V. Rodríguez" <evazquez@insys-corp.com.mx> wrote:
>
> But I pretend that automatically when I made an INSERT INTO table (month,
> day, time) values (A,B,C) the primary key update his value increasing by
one
>
>
> I dont know how to do this, Iam using Postgres 7.4 with PgAdminIII

Depending on what you really want sequences might be the solution.
Sequences really only provide you with unique values. If you really need
the values not have any gaps in the numbers then you will need to do
more work (especially if you will be deleting rows).

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Primary Key
Next
From: Michael Guerin
Date:
Subject: Re: page x is unitialized