[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Tomasz Wegrzanowski
Subject: Re: [Shopsuite-dev] rational numbers plugin to pg
Date: Mon, 6 Aug 2001 22:55:59 +0200
User-agent: Mutt/1.3.20i

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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]