Many thanks to all who have responded. I hope to be as helpful to the list someday as each of you have been. Thanks...
On Thursday 11 November 2004 10:04 am, Terry Lee Tucker saith: > 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 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 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? > > Version: > PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 > 20030502 (Red Hat Linux 3.2.3-42) > > Thanks for your input... > -- > > Work: 1-336-372-6812 > Cell: 1-336-363-4719 > email: [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Quote: 80 "Let us pray for the salvation of all of those who live in their totalitarian darkness -- pray that they will discover the joy of knowing God. But until they do, let us be aware that while they preach the supremacy of the state, declare its omnipotence over individual man, and predict its eventual domination of all peoples on the earth, they are the locus of evil in the modern world." --Ronald Reagan Work: 1-336-372-6812 Cell: 1-336-363-4719 email: [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
