Saturday, 15 March 2014

postgresql - Are the SQL, Postgres OIDs are dyanamic or static -



postgresql - Are the SQL, Postgres OIDs are dyanamic or static -

i'm new postgres oids. want know, wre sql, postgres oids dynamic or static? means after creating oids there possibility alter them automatically or manually?

postgresql oid static, not survive dumping , restoring database, should not rely on it.

actually, in postgresql 8.1 , later, configuration parameter default_with_oids false default, means unless utilize create table using with oids option, oids not nowadays in table.

so, long story short - oids thing of past. not utilize it, not rely on it, forget it.

postgresql oid

No comments:

Post a Comment