OID from insert has extra letter
От | darcy@druid.net (D'Arcy J.M. Cain) |
---|---|
Тема | OID from insert has extra letter |
Дата | |
Msg-id | m14NRlT-000AYIC@druid.net обсуждение исходный текст |
Ответы |
Re: OID from insert has extra letter
|
Список | 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@{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.
В списке pgsql-hackers по дате отправления: