Re: nooby q: how get a row just inserted?

yes i would suggest using OID
included in Postgres distro is a sample create table,index named
fti.pl

does this answer your question?
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

> Date: Sat, 30 May 2009 18:02:26 -0400
> From: kentilton(at)gmail(dot)com
> Subject: [GENERAL] nooby q: how get a row just inserted?
> To: pgsql-general(at)postgresql(dot)org
>
> I am probably breaking the rules here which is why I have a problem, but
> here goes: I am trying to build an audit trail skeleton of all my table
> inserts. Everything table has a column for the serial ID of an audit
> trail table row I will create for each transaction or batch of
> transactions if I like. My problem is that the audit trail table as I
> conceive it does not have a natural primary key. I do have serial id and
> timestamp columns supplied by PG, but being supplied by PG I need to
> read back the row to get at their values.
>
> If I were using OIDs on the table I realize the insert returns the oid
> created, but (so far) I am not.
>
> Am I going to have to use oids or fake a distinguishing column I can use
> to read back an audit trail row just after inserting it?
>
> I was hoping there was some select magic that would let me insert a row
> within a select which extracted the PG-allocated serial id column, but I
> do not see anything like that.
>
> kt
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
Hotmail® goes with you.
http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=TXT_TAGLM_WL_HM_Tutorial_Mobile1_052009