CAST SQL pane - Mailing list pgadmin-support

From Ódor Balázs Péter
Subject CAST SQL pane
Date
Msg-id 51A09B48.6060801@obiserver.hu
Whole thread Raw
Responses Re: CAST SQL pane
List 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




pgadmin-support by date:

Previous
From: Bastiaan Olij
Date:
Subject: Re: pgAdmin3 restore data only
Next
From: Dave Page
Date:
Subject: Re: CAST SQL pane