Big thank you seconded!

Posted Jan 21, 2005 1:01 UTC (Fri) by zblaxell (subscriber, #26385)
In reply to: Big thank you seconded! by ccyoung
Parent article: PostgreSQL 8.0.0 released

"un-defaulted oids" - and good riddance, I say. I can finally stop
writing "without oids" except for the extremely rare occurrences where I
actually want a table that can be inherited from. Man, that was
annoying. ;-)

Am I missing something, or is there very little useful about OO tables
that can't be achieved with some rules and triggers on a conventional (or
at least non-OO) database? Seems to me the OID does basically the same
thing an integer sequence primary key does, except using built-in
facilities instead of some views and insert/update/delete hooks. Does the
back-end do some incredibly efficient organization of tables with an
inheritance relationship, or is it just a legacy PostgreSQL-specific
syntax for something that could now be implemented in plain SQL?