I'm new to Postgres OIDs. I want to know, wre the SQL, Postgres OIDs are dynamic or static? Means after creating OIDs is there any possibility to change them automatically or manually?
Asked
Active
Viewed 215 times
1 Answers
3
PostgreSQL OID is static, but it will not survive dumping and restoring the database, so you should NOT rely on it.
Actually, in PostgreSQL 8.1 and later, configuration parameter default_with_oids is false by default, which means that unless you use CREATE TABLE using WITH OIDS option, OIDs will NOT be present in your table.
So, long story short - OIDs are thing of the past. Do not use it, do not rely on it, forget about it.
mvp
- 111,019
- 13
- 122
- 148
-
3"Do not use it, do not rely on it, forget about it." +1 – Frank Heikens Feb 14 '13 at 14:13