"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > Ragnar Hafstað wrote: >> On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote: >>> If I understand right, oids are globally >>> unique within your database. >> >> I am affraid not > oids are globally unique within the catalog. ... until the OID generator wraps around, and then they aren't so unique anymore. You can enforce uniqueness within a particular table by creating a unique index on the OID column, but that's about as much as you can guarantee. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend