pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Georgi Kolev <geo_kolev@mail.ru>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PQoidValue - get last ID of primary key after INSERT - small fix
Date: Thu, 10 Aug 2006 14:40:45 -0400
Message-ID: <17604.1155235245@sss.pgh.pa.us> (raw)
In-Reply-To: <ebchh2$opp$1@sea.gmane.org>
References: <ebchh2$opp$1@sea.gmane.org>

Georgi Kolev <geo_kolev@mail.ru> writes:
> The easiest way to fix the problem were to fix heap_insert() to get the 
> right value in case there is no OID column declared in the table.

Not a chance.  I could make a list of objections to that that's longer
than your patch, but the short of it is that this is a completely
inappropriate level of the system to be doing that kind of work in.

What we *are* working on is INSERT RETURNING (in fact I'm about to start
work on reviewing/committing that patch right now...), which is a much
more general solution to the problem.

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <17604.1155235245@sss.pgh.pa.us>
Permalink:  ../17604.1155235245@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/17604.1155235245@sss.pgh.pa.us

 · 

reply

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-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, geo_kolev@mail.ru
  Subject: Re: PQoidValue - get last ID of primary key after INSERT - small fix
  In-Reply-To: <17604.1155235245@sss.pgh.pa.us>

* 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