Sharing a user defined type - Mailing list pgsql-sql

From Luiz Renuncio
Subject Sharing a user defined type
Date
Msg-id 376FCCEF.6BC887DD@ipf.uni-karlsruhe.de
Whole thread Raw
List pgsql-sql


To: pgsql-sql@postgresql.org
Subject: Sharing a user defined type
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

we created a new data type (a 3d point) and the functions to access it.
Everything works all right when we log as the DB administrator ( who
created type and function).

Now we want to share the new existing data type with other users and
groups that do not have permission to execute data and function
creation. The question is: how can we share new data types with other
users than their creator.

We have been looking for an answer in the whole pgsql docs, man pages,
etc but nothing was found. Does anybody knows the answer?

We'd appreciate any help...

Thanks
L. E. Renuncio


pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [SQL] Trouble with massive select statement.
Next
From: "Deva Vejay"
Date:
Subject: Max () of an empty table... I need it to return 0 any ideas?