Thread: binary-compatible of pgCast

binary-compatible of pgCast

From
"Hiroshi Saito"
Date:
Hi Dave.

I have one cast of binary-compatible for largeobject.
Though it is hardly made except for it,
it thinks that we must show the policy of it.

This is made by psql.
CREATE CAST (lo AS integer) WITHOUT FUNCTION;
It doesn't appear on pgadmin for the limitation.

But, though it is binary-compatible,
Cast of the next which is supposed to be restricted can be made by Dialog.
CREATE CAST (timestamp AS int8)  WITHOUT FUNCTION  AS EXPLICIT;
This shouldn't be made if it is here because it is restricted.

I want to handle this as an effective thing.
It can be handled with this patch.
Any Comment?

Regards,
Hiroshi Saito





Attachment

Re: binary-compatible of pgCast

From
"Dave Page"
Date:
Thanks Hiroshi, patch applied.

> -----Original Message-----
> From: Hiroshi Saito [mailto:saito@inetrt.skcapi.co.jp]
> Sent: 09 September 2003 03:49
> To: Dave Page
> Cc: Andreas Pflug; pgadmin-hackers@postgresql.org
> Subject: binary-compatible of pgCast
>
>
> Hi Dave.
>
> I have one cast of binary-compatible for largeobject.
> Though it is hardly made except for it,
> it thinks that we must show the policy of it.
>
> This is made by psql.
> CREATE CAST (lo AS integer) WITHOUT FUNCTION;
> It doesn't appear on pgadmin for the limitation.
>
> But, though it is binary-compatible,
> Cast of the next which is supposed to be restricted can be
> made by Dialog. CREATE CAST (timestamp AS int8)  WITHOUT
> FUNCTION  AS EXPLICIT; This shouldn't be made if it is here
> because it is restricted.
>
> I want to handle this as an effective thing.
> It can be handled with this patch.
> Any Comment?
>
> Regards,
> Hiroshi Saito
>
>
>
>
>