Thursday, August 2, 2018

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

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/09184afd-1ee0-4506-a785-14e7ae559f1f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment