Re: [HACKERS] Understanding oid for a record

2006-12-18 Thread Tom Lane
"Brusser, Michael" <[EMAIL PROTECTED]> writes: > Can I assume that oid for any new record will be larger than oid on any > other existing rows? No; that will fail once the installation has consumed 4G OIDs. The counter just wraps around. However, if you pay attention to the OID value returned in

Re: [HACKERS] Understanding oid for a record

2006-12-18 Thread Richard Huxton
Brusser, Michael wrote: I ran into a situation with the query that needs to fetch the last record from the table. The table schema wasn't really designed to support this, (no serial id, or anything else I could use) so SQL makes use of max(create_date) which has a resolution of 1 second and thus