From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | How many users may be created ? |
Date: | 2000-11-28 23:43:49 |
Message-ID: | 3A244335.8E6B638C@sayegh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
i have to enhance my shopsystem by a simple closed user group.
One of our customers wants to give some of his customers
"special prices".
Up to now I used mysql and therefore used one single db-user for the
whole shop.
The customers were assigned a (auto increment) number for
identification.
So far so bad :|
Now I would like to use postgresql because of transactions, views,
groups etc.
(BTW: is one of the 7.1 snapshots stable enough for real usage ? (8k
limit, outer joins)).
1.)
Would it be wise to "CREATE USER ..." for every new customer (even the
ones without
special prices)?
That would easily mean >100.000 db-users. Where's the limit ?
If the answer is yes:
2.)
How can I achieve that A sees the prices for A and B the prices for B ?
I guess that this is what views are made for :)
example:
articles:
article | name | defaultprice
-------------------------------
235 | burger | 13
specials:
user | article | price
----------------------
A | 235 | 7
B | 235 | 11
So, now my shop uses the account for user A to login.
I would like to "SELECT PRICE FROM WHATEVER WHERE ARTICLE=235" without
JOINing the tables manually.
I guess, that because OUTER JOINs are not supported (are they in 7.1
snapshot?) it complicates
the whole thing (If the user has no special-prices ...).
I really have know clue about views and rules and so on.
I would appreciate ANY help/hint/docs ...
--
Nabil Sayegh
From | Date | Subject | |
---|---|---|---|
Next Message | Erion, Paul | 2000-11-29 19:57:01 | creating database system under Windows 2000 [i.e., running 'initd b'] |
Previous Message | Brian Aker | 2000-11-28 21:12:29 | to_days(now()) |