Jasbinder Singh Bali wrote:
Hi,
What would be the benefit of creating tables with OIDs as against one's not
with OIDs
Giving a unique identifier to each row inserted has some extra efficiency
factor involved or what.
OIDs are used by the various system tables.
Historically, all user tables had them too.
There's no reason to use them in a new system - they offer no advantages
over an ordinary integer primary-key.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
