Friday, October 5, 2018

[google-cloud-sql-discuss] Re: cannot CREATE CAST PostgreSQL 9.6

We need custom casts to simplify certain kinds of queries. This is a useful feature in general given postgres' support of custom data types. Its sad there is no easy way to do this.

-Daniel

On Thursday, August 2, 2018 at 1:47:18 PM UTC-7, George (Cloud Platform Support) wrote:
Hello Javier, 

To be able to create a cast, you must own the source or the target data type and have USAGE privilege on the other type. You may have a look at the "CREATE CAST" documentation page

If you use WITHOUT FUNCTION, you must enjoy superuser privileges. This is never the case in Cloud SQL PostgreSQL. In what context do you call the CREATE CAST statement? What would you like to achieve? A detailed use-case would definitely help in defining and clarifying the scope of the issue. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6c4996b4-e3c8-46a0-b8ea-c4ef43781f55%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment