Hi,
Im using pgAdmin 1.16.1 on Windows 7 64bit, connected to an PostgreSQL
9.2.4.
Im navigate in Object browser to database -> "Casts" ->
"text->http.user_agent", and the "SQL pane" is:
-- Cast: "text->http.user_agent"
-- DROP CAST (text AS http.http.user_agent)
CREATE CAST (text AS http.http.user_agent)
WITH FUNCTION http.text_user_agent(text);
Errors:
1. The full name of my custom type is: http.user_agent
2. missing final ";" in "DROP CAST" command.
So, the correct SQL pane's value is:
-- Cast: "text->http.user_agent"
-- DROP CAST (text AS http.user_agent);
CREATE CAST (text AS http.user_agent)
WITH FUNCTION http.text_user_agent(text);
Regards,
Balazs
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
