I'm a fan of PostgreSQL, but I've found certain T-SQL features that pg does not ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

dhd415 on May 10, 2017 | parent | context | favorite | on: Azure Database for MySQL and PostgreSQL

I'm a fan of PostgreSQL, but I've found certain T-SQL features that pg does not have such as manual transaction management within stored procedures to be very useful in certain applications.

koolba on May 10, 2017 | [–]

It's doable but quite hackish if you use a loopback FDW or dblink. Kind of a kludge to get autonomous transactions.

rosser on May 10, 2017 | [–]

Would SAVEPOINTs offer a viable alternative for meeting that need?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact