Re: duda sobre oids

Hola la
documentacion(http://www.postgresql.org/docs/9.4/static/datatype-oid.html)
te dice que es OID:

Object identifiers (OIDs) are used internally byPostgreSQLas primary
keys for various system tables. OIDs are not added to user-created
tables, unlessWITH OIDSis specified when the table is created, or
thedefault_with_oids
<http://www.postgresql.org/docs/9.4/static/runtime-config-compatible.html#GUC-DEFAULT-WITH-OIDS>configuration
variable is enabled. Typeoidrepresents an object identifier. There are
also several alias types
foroid:regproc,regprocedure,regoper,regoperator,regclass,regtype,regconfig,
andregdictionary.Table 8-24
<http://www.postgresql.org/docs/9.4/static/datatype-oid.html#DATATYPE-OID-TABLE>shows
an overview.

Theoidtype is currently implemented as an unsigned four-byte integer.
Therefore, it is not large enough to provide database-wide uniqueness in
large databases, or even in large individual tables. So, using a
user-created table's OID column as a primary key is discouraged. OIDs
are best used only for references to system tables.

Theoidtype itself has few operations beyond comparison. It can be cast
to integer, however, and then manipulated using the standard integer
operators. (Beware of possible signed-versus-unsigned confusion if you
do this.)

Segun leo tu correo, puede que te convenga darle un ojo al tipo de dato
UUID(http://www.postgresql.org/docs/9.4/interactive/datatype-uuid.html)
y a sus
extensiones(http://www.postgresql.org/docs/9.4/interactive/uuid-ossp.html)

saludos

On 02/06/15 10:53, Esneiker Enriquez Cabrera wrote:
> luso que nunca se repite en el mundo enter