From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Ódor Balázs Péter <balazs(at)obiserver(dot)hu> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: CAST SQL pane |
Date: | 2013-05-26 22:02:51 |
Message-ID: | CA+OCxozkLQVjk8_BOw8UZ6_SkRW1isW9HCD2WGEp8z8TShss6g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Sat, May 25, 2013 at 11:06 AM, Ódor Balázs Péter <balazs(at)obiserver(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Milan Perovic | 2013-05-30 14:30:58 | SQL window in 1.16.1 |
Previous Message | Ódor Balázs Péter | 2013-05-25 11:06:48 | CAST SQL pane |