On 04/10/2011 16:51, J.V. 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.
Something like this? -
update my_table set my_column = nextval('my_sequence');
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
