I'm migrating existing application to Amazon RDS PostgreSQL. The application has cross-database support and for compatibility reasons it includes the following SQL:
CREATE CAST (varchar AS numeric) WITH INOUT AS ASSIGNMENT
On plain PostgreSQL, this requires superuser. On Amazon RDS PostgreSQL this fails with
ERROR: must be owner of type character varying or type numeric
- Is there a way to create such a cast in Amazon RDS (perhaps via administrative web interface)?
- If this is not possible, then why? Is this deliberate limitation (e.g. is the cast something dangerous) or just a missing feature?
Note: I guess that whether this is assignment or implicit cast is irrelevant, but included this information for completeness.