On Mon, Feb 16, 2009 at 7:36 PM, johnf <jfabiani(at)yolo(dot)com> wrote:
> Hi,
> I'm not to sure this is possible.
>
> I need to replace a primary key (pkid) with the value of a different field.
> I have
> pkid = 200
> attendid = 301
>
> I need the pkid = 301
>
> But there may or may not be a pkid that already exist that has the value of
> 301. The attendid is unique and the pkid data type is serial (has a
> sequence).
If the FK is on update cascade just update it. and setval() the
sequence to be max(pkid)+1.