[Top][All Lists]

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

Re: [ShopSuite-dev] shop and drop

From: Tomasz Wegrzanowski
Subject: Re: [ShopSuite-dev] shop and drop
Date: Thu, 23 Aug 2001 01:30:56 +0200
User-agent: Mutt/1.3.20i

On Wed, Aug 22, 2001 at 03:32:24PM +0100, Davi Leal wrote:
> > Here are two scripts: shop.psql and drop.psql
> >
> > drop.psql drops all shopDB tables from db, so newer version can be
> > added (that's mostly for debug)
> We have scripts/clean.psql (DELETE). Must the drop.psql (DROP) be added to the
> scripts/ directory?. I do not think so. At least not now. What do you think?.

clean.psql doesn't remove tables, drop.sql does.

$ psql shopdb <drop.sql
$ psql shopdb <shop.sql # new version

$ dropdb shopdb
$ createdb shopdb
$ su
# su postgres
$ psql shopdb <rational.sql
$ ^D
# ^D
$ psql shopdb shop.sql # new version

> Agreed. And ... What about using 'UNIQUE' too into the products.shortdsc 
> field?.
> See the diff of attached shop.psql.

It is already UNIQUE due to CREATE UNIQUE INDEX on it.

reply via email to

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