On Thu, Nov 11, 2004 at 10:04:30 -0500, Terry Lee Tucker <[EMAIL PROTECTED]> wrote: > Greetings, > > Here is a simple question: > > Is it ok to put a unique index on the oid for my tables? We are in the > process
Yes, but you may occasionally have insert failures if the oid wraps around and you try to reuse one on an insert. > of moving from Progress Software to PostgreSQL. In the Progress world, you > can always uniquely, and quickly find a record by using their version of oid, > which is recid. I remember reading somewhere that the oid could be You should probably just use a normal column named recid and not try to use the special oid column to do this. > duplicated across the cluster, but would not be duplicated in a single table. > Maybe I dreamed it. What is the recommendation regarding this and why? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
