Re: List of "binary-compatible" data types

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>

To: Thom Brown <thom@linux.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2013-11-05T01:21:27Z

Lists: pgsql-hackers

Thom,


> SELECT
>   castsource::regtype::text,
>   array_agg(casttarget::regtype order by casttarget::regtype::text) casttargets
> FROM pg_cast
> WHERE castmethod = 'b'
> GROUP BY 1
> ORDER BY 1;

Are we actually covering 100% of these for ALTER COLUMN now?


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Commits

Avoid some table rewrites for ALTER TABLE .. SET DATA TYPE timestamp.
- 3c5926301aea 12.0 landed
Disable transforms that replaced AT TIME ZONE with RelabelType.
- c22ecc6562aa 10.0 cited
Add transform functions for AT TIME ZONE.
- b8a18ad4850e 9.5.0 cited