Re: safely exchanging primary keys?

From: jr <jorg(dot)raskowski(at)tailorware(dot)org(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: safely exchanging primary keys?
Date: 2010-05-24 11:46:55
Message-ID: htdovf$1k92$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tailorware(dot)org(dot)uk)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Louis-David Mitterrand 2010-05-24 14:05:22 Re: safely exchanging primary keys?
Previous Message Louis-David Mitterrand 2010-05-24 08:51:09 safely exchanging primary keys?