Many PostgreSQL features are not available in Redshift, particularly those which are not suitable for a database cluster or for analytics, and those that Amazon didn’t consider important enough to spend the necessary resources to maintain them.
Read more