CAST SQL pane

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: Raw Message | Whole Thread | 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

Responses

Browse pgadmin-support by date

  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