Oracle vs. PostgreSQL – A Comment

Re:Oracle vs. PostgreSQL – A Comment by atombender on Saturday May 30, 2020 @12:48PM (#23362480)

Very few databases support transactional DDL, meaning that you can do something like:

  BEGIN;
  DROP TABLE foo;
  CREATE TABLE bar (t int);
  ROLLBACK;

...and it will just work as you expect. Oracle doesn't, nor does MSSQL.

As far as I know, other than Postgres, only Sybase ASE, Informix, DB2 UDB, and Firebird support transaction DDL.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL – A Comment by castorp on Saturday May 30, 2020 @05:04PM (#23364712)

> Very few databases support transactional DDL

Postgres, SQL Server, Firebird, DB2, SQLite, Ingres, Informix, Teradata, Vertica all support transactional DDL

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL – A Comment by nycdotnet on Saturday May 30, 2020 @05:26PM (#23364895)

SQL Server partially supports it - indexes for example are not versioned which causes snapshot transactions to fail if someone rebuilds an index - even if it’s not in scope of the snapshot.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL – A Comment by throwaway_pdp09 on Saturday May 30, 2020 @05:42PM (#23365025)

That doesn't sound right by my experience, Could you give a link please? I'm concerned I've not heard of this. Probably because it's MVCC/snapshot isolation which I'm not familiar with.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL – A Comment by mayoff on Saturday May 30, 2020 @02:15PM (#23363292)

DDL is transactional in SQLite.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL – A Comment by throwaway_pdp09 on Saturday May 30, 2020 @01:23PM (#23362819)

Well, https://www.mssqltips.com/sqlservertip/4591/ddl-commands-in-...

[ Parent | on HN ]