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

[Davi Leal]

> > > > 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

Uhmm. I agree with you now. Warn when the need of special privileges is removed.