On Sat, Dec 03, 2005 at 03:07:19PM -0800, Uwe C. Schroeder wrote: > the ctid seems to be the solution to my problem. I'm inserting the record in > a > transaction so the ctid shouldn't change while the transaction isn't finished > (either rolled back or committed). > One question though. How would I get the ctid of the just inserted record. > GET > DIAGNOSTICS only handles row count and oid per the docs.
Right now you don't. :( ISTM there should be a way to get back the row you just inserted. Whether a ctid is the right way to do that I don't know... I'm going to move this over to -hackers to see what people over there have to say. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
