Re: Lock strategies! - Mailing list pgsql-general

From Jeff
Subject Re: Lock strategies!
Date
Msg-id 20031124092826.228bd067.threshar@torgo.978.org
Whole thread Raw
In response to Lock strategies!  (MaRcElO PeReIrA <gandalf_mp@yahoo.com.br>)
List pgsql-general
On Mon, 24 Nov 2003 10:20:07 -0300 (ART)
MaRcElO PeReIrA <gandalf_mp@yahoo.com.br> wrote:

> Hi guys,
>
> I have a simple table:
>
> teste=# \d forn
>                            Table "public.forn"
>  Column  |  Type   |                      Modifiers
> ---------+---------+-------------------------------------------------
> -----
>  id      | integer | not null default
> nextval('public.forn_id_seq'::text)
>  forn_id | integer |
>  descrip | text    |
>


Why not make forn_id a sequence as well?
then you simply call nextval('forn_id_seq')


--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

pgsql-general by date:

Previous
From: MaRcElO PeReIrA
Date:
Subject: Re: Lock strategies!
Next
From: Dave Cramer
Date:
Subject: Re: Lock strategies!