Re: Is this possible?

On Mon, Feb 16, 2009 at 7:36 PM, johnf <jfabiani@yolo.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.