Re: [Shopsuite-dev] rational numbers plugin to pg

[Tomasz Wegrzanowski]

On Mon, Aug 06, 2001 at 09:50:46PM +0100, Davi Leal wrote:
> > > It seems that the rational type load only works while the session where 
> > > it was
> > > loaded is open. What do you think about it?.
> >
> > New types are created per-database, you must:
> > davi$ createdb shop
> > davi$ su
> > root# su postgres
> > postgres$ psql shop <  rational.psql
> > postgres$ exit
> > root# exit
> > davi$ psql shop < shop.psql
> 
> OK. So, in order to install the final project version we will
> have to install the plug-in into the shop data base, not as
> a general postgres type. Right?. Is there a way to get "in catalog"
> the type added by a plug-in?.
>     ERROR:  Unable to locate type name 'rational' in catalog

There probably is, but I'd prefer it not to require special priviledges,
so it can be just part of shop.psql