Re: PRIMARY KEY

From: Richard Huxton <dev(at)archonet(dot)com>
To: Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PRIMARY KEY
Date: 2007-03-07 11:51:07
Message-ID: 45EEA72B.1020607@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Shavonne Marietta Wijesinghe wrote:
> Hello
>
> I have created a table
> CREATE TABLE MOD48_00_2007 ( ID text, N_GEN int PRIMARY KEY, FORMSTORE text, COD_NOTAIO text, PA_COGNOME text);
>
> And i insert the rows via a form in ASP. When the form loads i have a functin that goes and gets the value of the field N_GEN adds 1 to it and shows it to the user.
> The problem is when i have 2 users working at the same time.

Check the manuals for "sequences" and "serial type".

--
Richard Huxton
Archonet Ltd

In response to

  • PRIMARY KEY at 2007-03-07 11:35:58 from Shavonne Marietta Wijesinghe

Browse pgsql-sql by date

  From Date Subject
Next Message M.P.Dankoor 2007-03-07 11:57:57 Re: PRIMARY KEY
Previous Message Shavonne Marietta Wijesinghe 2007-03-07 11:35:58 PRIMARY KEY