Re: increment the primary key value without using sequences

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: roopa perumalraja <roopabenzer(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: increment the primary key value without using sequences
Date: 2007-07-29 13:37:41
Message-ID: 889B7471-25C6-4D05-9AA3-91BE11F9CFE0@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Jul 29, 2007, at 7:00 , roopa perumalraja wrote:

> I would like to know if its possible to increment the primary key
> field value of stocks table without using sequences by getting the
> next value of the pk field from the sequnce table ?

Why? Any other solution will cause performance issues.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mitchell Vincent 2007-07-30 02:28:10 Migration from SQLite Help (Left Join)
Previous Message roopa perumalraja 2007-07-29 12:00:09 increment the primary key value without using sequences