Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I create unique IDs for an existing set of records - Mailing list pgsql-sql

From Nick Fankhauser
Subject Re: How do I create unique IDs for an existing set of records
Date
Msg-id NEBBLAAHGLEEPCGOBHDGEELPENAA.nickf@ontko.com
Whole thread Raw
In response to Re: How do I create unique IDs for an existing set of records  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
> You are overthinking the problem; this should work:
> 
> update test set new_pk = nextval('test_new_pk_seq');

Thanks Tom! It did indeed work.

-Nick

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do I create unique IDs for an existing set of records
Next
From: "Josh Berkus"
Date:
Subject: Re: Wierd error for COPY command