Re: Proposal: CREATE CONVERSION - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Proposal: CREATE CONVERSION
Date
Msg-id 20020709.100735.35034016.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Proposal: CREATE CONVERSION  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposal: CREATE CONVERSION  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I believe the spec just demands USAGE on the underlying function for
> the TRANSLATE case, and I don't see why it should be different for
> CONVERT.  (In principle, if we didn't use a C-only API, you could
> just call the underlying function directly; so there's little point
> in having protection restrictions different from that case.)

Ok, so:

(1) a CONVERSION can only be dropped by the superuser or its owner.
(2) a grant syntax for CONVERSION is:
   GRANT USAGE ON CONVERSION <conversion_name> to   {<user_name> | GROUP <group_name> | PUBLIC} [, ...]
--
Tatsuo Ishii




pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: (A) native Windows port
Next
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: CREATE CONVERSION