From: Bruno Wolff III <bruno@wolff.to>
To: Matthew Nuzum <matt@followers.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: matching rows differing only by fkey,pkey
Date: Tue, 22 Jun 2004 12:27:04 -0500
Message-ID: <20040622172704.GA19163@wolff.to> (raw)
In-Reply-To: <200406221634.i5MGYcnb009716@ms-smtp-02.tampabay.rr.com>
References: <200406221634.i5MGYcnb009716@ms-smtp-02.tampabay.rr.com>
On Tue, Jun 22, 2004 at 12:34:35 -0400,
Matthew Nuzum <matt@followers.net> wrote:
> Any ideas? If someone has an alternate method of achieving the same result
> I'd be excited to hear about it.
A more precise formulation of what exactly you are doing might be helpful.
From your description it sounds like you should already know the primary
key of the row you are copying and can use currval to get the id of the
row just inserted. I get the impression that you are manually using these
values instead of having a script do it. But it should be easy to write
a script that does this for you.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, matt@followers.net
Subject: Re: matching rows differing only by fkey,pkey
In-Reply-To: <20040622172704.GA19163@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox