sql-ledger-users

Re: Adding PostgreSQL PRIMARY KEY - bingo

[alta <al...@al...>]

Roderick ...

Your suggestion works, at least it did on a test table:  Thanks!

     CREATE UNIQUE INDEX cs1_pk ON customer (id);

I just installed Version 1.8.  Looks very nice!  However, I think the
"bin" column is missing from the "part" table...

Regards ... Reed

On Tuesday 18 December 2001 21:26, you wrote:
> On Tue, 18 Dec 2001, alta wrote:
> > Thanks Thomas ...
> >
> > However, your suggestion produced an error.  psql was run from
> > user postgres, version 7.1.3-11, with the following results:
> >
> > =# ALTER TABLE customer ADD CONSTRAINT cs1 UNIQUE (id);
> >
> > ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that
> > constraint type
>
> From the PostgreSQL man page on alter_table
>
>        In  the  current  implementation,  only  FOREIGN  KEY con
>        straints can be added to a table. To create  or  remove  a
>        unique constraint, create a unique index (see CREATE INDEX
>        [create_index(l)]).
>
> Try
>
> 	CREATE UNIQUE INDEX cs1_pk ON customer (id);
>
> Not sure if Dieter's code will trap the error returned if a
> duplicate ID is inserted or updated.
>
>
> Cheers,
> Rod

--
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

-------------------------------------------------------

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Adding PostgreSQL PRIMARY KEY - bingo

[Roderick A. A. <raa...@ti...>]

On Tue, 18 Dec 2001, alta wrote:

> I just installed Version 1.8.  Looks very nice!  However, I think the
> "bin" column is missing from the "part" table...

I must have missed something.  Where is 1.8?  I've only seen 1.6.13 in
the download section.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: Adding PostgreSQL PRIMARY KEY - bingo

[Ho-Sheng H. <qa...@ne...>]

On Tue, Dec 18, 2001 at 10:24:15PM -0800, Roderick A. Anderson wrote:
> On Tue, 18 Dec 2001, alta wrote:
> > I just installed Version 1.8.  Looks very nice!  However, I think the
> > "bin" column is missing from the "part" table...

> I must have missed something.  Where is 1.8?  I've only seen 1.6.13 in
> the download section.

Yeah, really! Is this a private pre-release?

-Qaexl-

Re: Adding PostgreSQL PRIMARY KEY - bingo

[Dieter S. <dsi...@sq...>]

I am still missing a few translations.

So far I got Arabic, Brazilien Portuguese, Czech, German, Danish, Spanish,
French, Italian, Norwegian

I am missing

Simplified Chinese, Estonian, Farsi, Dutch, Portuguese, Polish, Swedish, 
Traditional Chinese.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 19 Dec 2001, Ho-Sheng Hsiao wrote:

> On Tue, Dec 18, 2001 at 10:24:15PM -0800, Roderick A. Anderson wrote:
> > On Tue, 18 Dec 2001, alta wrote:
> > > I just installed Version 1.8.  Looks very nice!  However, I think the
> > > "bin" column is missing from the "part" table...
> 
> > I must have missed something.  Where is 1.8?  I've only seen 1.6.13 in
> > the download section.
> 
> Yeah, really! Is this a private pre-release?
> 
> -Qaexl-
> 
>