Postgres Pro
Downloads
Home   >   mailing lists

Re: increment the primary key value without using sequences - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: increment the primary key value without using sequences
Date
Msg-id 889B7471-25C6-4D05-9AA3-91BE11F9CFE0@seespotcode.net
Whole thread Raw
In response to increment the primary key value without using sequences  (roopa perumalraja <roopabenzer@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Michal Kedziora"
Date:
Subject: Re: raise exception and transaction handling
Next
From: "Mitchell Vincent"
Date:
Subject: Migration from SQLite Help (Left Join)