| From: | Ódor Balázs Péter <balazs(at)obiserver(dot)hu> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | CAST SQL pane |
| Date: | 2013-05-25 11:06:48 |
| Message-ID: | 51A09B48.6060801@obiserver.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2013-05-26 22:02:51 | Re: CAST SQL pane |
| Previous Message | Bastiaan Olij | 2013-05-24 02:32:52 | Re: pgAdmin3 restore data only |