Re: 8.1, OID`s and plpgsql - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: 8.1, OID`s and plpgsql
Date
Msg-id 339d7528c8e6a85f59bf049fe61a3029@biglumber.com
Whole thread Raw
In response to Re: 8.1, OID's and plpgsql  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Related to the original question though, is there actually any way to
> get the ctid of a row that was just inserted?

No. You'd have to identify the rows some other way (a sequence is
the canonical way), and then grab the ctid from that.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200512042018
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFDk5WBvJuQZxSWSsgRAnaaAKDswxUhZH4wHAJJDTZSBtTVNY/9/gCgk3La
KWRzIVIeamQZvhr+TaFp4RY=
=Nevb
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Havasvölgyi Ottó
Date:
Subject: Creating then dropping primary key constraint
Next
From: Jonathan Schreiter
Date:
Subject: Re: postgresql jdbc connect via hostname instead of just ip