Re: safely exchanging primary keys? - Mailing list pgsql-sql

From jr
Subject Re: safely exchanging primary keys?
Date
Msg-id htdovf$1k92$1@news.hub.org
Whole thread Raw
In response to safely exchanging primary keys?  (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
List pgsql-sql
hi Louis-David,

> tmp := nextval('cabin_type_id_cabin_type_seq');

seems to me you're adding a newly created key value (for which there 
isn't a record yet).

-- 

regards, jr.  (jr@tailorware.org.uk)


pgsql-sql by date:

Previous
From: jr
Date:
Subject: Re: return %ROWTYPE from function
Next
From: "Plugge, Joe R."
Date:
Subject: Re: how to construct sql