On Tue, Oct 4, 2011 at 9:51 AM, J.V. <jvsrvcs@xxxxxxxxx> wrote: > 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. Not even temporary sequences to do the just the renumbering? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general