[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Shopsuite-dev] rational numbers plugin to pg
From: |
Davi Leal |
Subject: |
Re: [Shopsuite-dev] rational numbers plugin to pg |
Date: |
Tue, 07 Aug 2001 00:24:02 +0100 |
> > > > 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.