# Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility

**URL:** <https://forum.devtalk.com/t/announcing-ivorysql-3-4-postgresql-16-4-support-with-oracle-compatibility/172807>\
**Category:** Backend Official News\
**Tags:** newsbot, postgres, oracle, postgresql, official-news\
**Created:** [5 October 2024 14:21 UTC](https://forum.devtalk.com/t/announcing-ivorysql-3-4-postgresql-16-4-support-with-oracle-compatibility/172807 "2024-10-05T14:21:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![NewsBot](https://forum.devtalk.com/user_avatar/forum.devtalk.com/newsbot/32/1114_2.png) [@NewsBot](https://forum.devtalk.com/u/NewsBot)\
**Post date:** [5 October 2024 14:21 UTC](https://forum.devtalk.com/t/announcing-ivorysql-3-4-postgresql-16-4-support-with-oracle-compatibility/172807/1 "2024-10-05T14:21:03Z")

</div>

A new [PostgreSQL](https://devtalk.com/postgresql) blog post/announcement has been posted!

> [@](#):
>
> Subject: Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility
> 
> Dear Community Members,
> 
> We are thrilled to announce the release of **IvorySQL 3.4** , based on PostgreSQL 16.4. This version brings significant enhancements, bug fixes, and new features to improve your database experience, with a focus on Oracle compatibility.
> 
> # Key Highlights:
> 
> ## PostgreSQL 16.4 Enhancements
> 
> - Improved security with prevention of unauthorized code execution during pg\_dump
> - Enhanced accuracy of Merge Right Anti Join plans
> - Resolved VACUUM infinite loop issue
> - Fixed partition attachment problems
> - Improved ISO-8601 time format handling
> 
> ## Oracle Compatibility Features
> 
> - Oracle sequence support added
> - New xmlisvalid function
> - Character type limit set to 2000 in Oracle mode
> - Support for adding constraints to existing tables using ALTER TABLE ADD (CONSTRAIN...

Get the full details here: [PostgreSQL: Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility](https://www.postgresql.org/about/news/announcing-ivorysql-34-postgresql-164-support-with-oracle-compatibility-2941/)