table sequence, renumbering

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: table sequence, renumbering
Date: 2011-10-04 15:51:50
Message-ID: 4E8B2B96.3090809@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the absolute fastest way to populate a primary key / id column
from a named db sequence (disabled constraints and want to renumber the
primary key / id column from sequence.

cannot use auto inc or serial column because need to use generic
hibernate mapping files for multiple DB's in the end, but want a stored
proc to simple reorder a primary key int column pulling from a named
sequence, if there is a single command.

thanks

J.V.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-10-04 15:59:36 Re: LAPP server moving from 4 GB RAM to 16 GB - increase shared_buffers?
Previous Message Adam Cornett 2011-10-04 15:36:27 Re: LAPP server moving from 4 GB RAM to 16 GB - increase shared_buffers?