From: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | OID from insert has extra letter |
Date: | 2001-01-30 03:47:31 |
Message-ID: | m14NRlT-000AYIC@druid.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is very odd. I have a database app failing sometimes with an error
when I try to get back my inserted row. I do this to get all the fields
that were adjusted for defaults, triggers and rules. On an insert query
I expect to get the OID of the just inserted tuple. Once in a while I
get the wrong value. Here are two examples.
Get: 31930584, should be 3193058
Get: 31943386, should be 3194338
As you can see, there is an extra digit added. I am using PQoidStatus()
to get the OID. Is this the right way? Is it possible that there is
a buffer/terminating problem in the insert code? I assume that most
people are not examining this value so it may be that something slipped
through. Anyone else ever seen this?
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Cabido | 2001-01-30 03:49:41 | Re: How to modify type in table? |
Previous Message | The Hermit Hacker | 2001-01-30 03:24:08 | Re: [ANNOUNCE] PostgreSQL v7.1BETA4 Bundled and Available ... |