Re: Question about database restrict - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Question about database restrict
Date
Msg-id 20050315131850.GA2255@wolff.to
Whole thread Raw
In response to Re: Question about database restrict  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-general
On Tue, Mar 15, 2005 at 12:57:52 +0800,
  Qingqing Zhou <zhouqq@cs.toronto.edu> wrote:
>
>
>
> "Yu Jie" <webpurchasing@yahoo.com>  writes:
> > Hi all,
> >     If I want to restrict the maximum size of one
> > table to 5MB, restrict the maximum size of database
> > file to 100MB, how can I do that restriction?
> >     Is PostgreSQL8.0 support this function? I can't
> > find it in the manual of PostgreSQL.
>
> PG does not support this function directly. However, you may use OS provided
> functions to do this more or less.

However, this isn't really a good idea as if the database runs out of disk
space cleanup might not be fun.

Perhaps if you explain more about what you are doing we might have some
other possible solutions for you?

pgsql-general by date:

Previous
From: Secrétariat
Date:
Subject: Localization problems between Access and PostgresSQL 8
Next
From: tony
Date:
Subject: Re: prelimiary performance comparison pgsql vs mysql