RE: Available Space - Mailing list pgsql-novice

From Sykora, Dale
Subject RE: Available Space
Date
Msg-id 415DD0BB9FAFD011B6E700805FBEB68E08AD93FB@exchou-ca0801bk.im.hou.compaq.com
Whole thread Raw
In response to Available Space  (Mauricio Alarcon <malarcon@webdepot.com.co>)
List pgsql-novice
Perhaps use a trigger to delete old rows when new rows are inserted, or
change the write privlege on a table if row count reaches a certain level. I
haven't tried this myself, but this is the way I would approach it.  You
could also add logic to your apps/scripts to check row count before inserts.

Dale

-----Original Message-----
From: Mauricio Alarcon [mailto:malarcon@webdepot.com.co]
Sent: Wednesday, November 08, 2000 12:41 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Available Space


Hello!

I want to limit the available space in a table, How can I do that?

Tahnks

Mauricio Alarcon

pgsql-novice by date:

Previous
From: Mauricio Alarcon
Date:
Subject: Available Space
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] VACUUM AND VACUUM ANALYSE