On Wed, 15 Dec 1999, [EMAIL PROTECTED] wrote:
>6184 p2 R0:00 /usr/local/bin/postgres localhost postgres adcept SELECT
>20964 p6 S0:00 su - postgres
>23112 p4 S0:00 su - postgres
>27664 p2 R0:03 /usr/local/bin/postmaster -i
>
>bash: /bin/ps: Too many open files in system
I
Couldn't you restrict access to the table
and create views such as
CREATE VIEW BillsCustomerID001 AS
SELECT * FROM Bills WHERE CustomerID=001
CREATE VIEW BillsCustomerID002 AS
SELECT * FROM Bills WHERE CustomerID=002
etc.
and give Customer 001 access to BillsCustomerID001
give Cust