table sequence, renumbering - Mailing list pgsql-general

From J.V.
Subject table sequence, renumbering
Date
Msg-id 4E8B2B96.3090809@gmail.com
Whole thread Raw
Responses Re: table sequence, renumbering  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: table sequence, renumbering  (Raymond O'Donnell <rod@iol.ie>)
List 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.


pgsql-general by date:

Previous
From: Adam Cornett
Date:
Subject: Re: LAPP server moving from 4 GB RAM to 16 GB - increase shared_buffers?
Next
From: Scott Marlowe
Date:
Subject: Re: LAPP server moving from 4 GB RAM to 16 GB - increase shared_buffers?