Thank you Tom for your concise response. Your explanation is very helpfull.
We were aware of the wraparound issues, but this has worked so well for us
that we haven't explored changing it yet. Having a unique identifier per row
is most usefull in our situation and we didn't think we were anyw
Chris Kratz <[EMAIL PROTECTED]> writes:
> We aren't sure at this point if the problem we are having has to do with the
> fact that we drop and reload the test db quite often and so we are running
> into OID wraparound, or if it has to do with the fact that we recently went
> to 8.1 on this test
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
Terry Lee Tucker 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
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,
wh
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 07:04 am, Terry Lee Tucker 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 of moving from Progress Software to PostgreSQL. In the Progr
On Thu, 11 Nov 2004, Terry Lee Tucker wrote:
> 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 reci
Chris Sutton wrote:
>
> I would like to use the oid as a unique key for a table but in creating
> a test table and playing around with inserts, things don't seem to be
> working as I thought they would.
>
> Where am I going wrong?
There is a hidden column named 'oid'. Try "select oid, desc fr
