4 ms·
> 1)"temporal" / versioned tables / time consistent views of data Oracle doesn't have transactional DDL. It means if you drop a column or create a table, it co
by tajen 10y ago
> 1)"temporal" / versioned tables / time consistent views of data
Oracle doesn't have transactional DDL. It means if you drop a column or create a table, it commits your transaction automatically.
This is huge, because with PostgreSQL you can import a full database in a single transaction, and roll it back if anything goes wrong. You can upgrade a full application and roll back if anything goes wrong. No more partial-state headaches.
Therefore I'm not sure what "versioned tables" mean. Have you tried PostgreSQL's temporal tables extension, which seems to do what you mean?