On Sat, May 25, 2013 at 11:06 AM, Ódor Balázs Péter <bal...@obiserver.hu> wrote: > 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);
Thanks - I've committed a patch that fixes both of these issues. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
