Re: System vs non-system casts - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: System vs non-system casts
Date
Msg-id 20050412161331.GL17283@dcc.uchile.cl
Whole thread Raw
In response to Re: System vs non-system casts  ("Michael Paesold" <mpaesold@gmx.at>)
Responses Re: System vs non-system casts
List pgsql-hackers
On Tue, Apr 12, 2005 at 08:39:09AM +0200, Michael Paesold wrote:
> Tom Lane wrote:

> >The other possible solution that comes to mind is to invent the notion
> >that a cast has a specific owner (which arguably it should have anyway)
> >and then say that "system casts" are those whose owner is the original
> >superuser.
> 
> Just my toughts: I believe it's better when cast selection does not depend 
> on the search_path. It seems dangerous for objects that you don't usually 
> qualify with a schema. With all other objects in schemas I can think of, 
> you can easily write the full-qualified name.
>
> So I vote for the latter.

So casts created by the original superuser don't get dumped?  That's not
good IMHO.

But yes, schema-qualifying casts seems weird:'123'::someschema.user_type

Is that even accepted by the grammar?

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OUT parameters in PL/Java
Next
From: Tom Lane
Date:
Subject: Re: System vs non-system casts