Adding "quota user limit" using triggers

From: Andrea Peri <aperi2007(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Adding "quota user limit" using triggers
Date: 2011-06-09 06:14:00
Message-ID: BANLkTimCcSKAEmcGyeRfuXqdAs+tjOtGow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is possible the limit the size of an user (quota user) as space allocated
in a tablespace ?

I don't find this option in the 9.0 version of PG,
so I think it is not available.

Perhaps it should be possible to simulate it using triggers.

However before start to work on it , I like to have a confirm and if there
is some documentation or information on this
problem available.

Thx,

--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-06-09 06:39:42 Re: Adding "quota user limit" using triggers
Previous Message Craig Ringer 2011-06-09 03:46:08 Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres