Postgres Pro
Downloads
Home   >   mailing lists

Thread: CAST SQL pane

CAST SQL pane

From
Ódor Balázs Péter
Date:
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

Re: CAST SQL pane

From
Dave Page
Date:
On Sat, May 25, 2013 at 11:06 AM, Ódor Balázs Péter <balazs@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