On Wed, Mar 23, 2005 at 20:47:36 +0200,
Andrus <[EMAIL PROTECTED]> wrote:
>
> I thought about this.
>
> 1. It seems that user prefer to see separate numbers for each sequence.
>
> First invoice has number 1 , second invoice has number 2
This suggests that invoices for different categories ca
>> I'm trying to move existing ERP database to Postgres
>>
>> My database contains table of document headers:
>>
>> CREATE TABLE document (
>> category CHAR,
>> sequence NUMERIC(7),
>> ... a lot of other columns ... ,
>> PRIMARY KEY (category, sequence) ) ;
>>
>> and document rows:
>>
>> CREATE TAB
Reply from Bruno Wolff III, re-posted from mail:
> >>I have 120 concurrent users inserting documents. Mostly they are using
> >>10
> >>different document types. Each type should have separate numbering.
> >>They
> >>insert 30 documents per minute in peak hours.
> >
> >You really should think abou
On Tue, 15 Mar 2005 08:39 pm, Andrus wrote:
> >> > I have table containing different types of documents (type A, B and C).
> >> >
> >> > Each document type must have separate sequential ID starting at 1
> >> >
> >> > ID of first inserted record of type A must be set to 1
> >> > ID of first inserted
>> > I have table containing different types of documents (type A, B and C).
>> >
>> > Each document type must have separate sequential ID starting at 1
>> >
>> > ID of first inserted record of type A must be set to 1
>> > ID of first inserted record of type B must be also set to 1
>> > ID of secon
On Sat, Mar 19, 2005 at 22:37:55 +0200,
Andrus Moor <[EMAIL PROTECTED]> wrote:
> >> I have table containing different types of documents (type A, B and C).
> >>
> >> Each document type must have separate sequential ID starting at 1
> >>
> >> ID of first inserted record of type A must be set to 1
>> I have table containing different types of documents (type A, B and C).
>>
>> Each document type must have separate sequential ID starting at 1
>>
>> ID of first inserted record of type A must be set to 1
>> ID of first inserted record of type B must be also set to 1
>> ID of second record of ty
On Sun, 13 Mar 2005 02:59 pm, Bruno Wolff III wrote:
> On Sat, Mar 12, 2005 at 23:05:41 +0200,
> Andrus Moor <[EMAIL PROTECTED]> wrote:
> > I have table containing different types of documents (type A, B and C).
> >
> > Each document type must have separate sequential ID starting at 1
> >
> > I
On Sat, Mar 12, 2005 at 23:05:41 +0200,
Andrus Moor <[EMAIL PROTECTED]> wrote:
> I have table containing different types of documents (type A, B and C).
>
> Each document type must have separate sequential ID starting at 1
>
> ID of first inserted record of type A must be set to 1
> ID of first
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first inserted record of type B must be also set to 1
ID of second record of type A must be set to
10 matches
Mail list logo