Re: Limiting Row Count In a Table??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Çağıl Şeker <cagils(at)biznet(dot)com(dot)tr>
Cc: "PostgreSQL-General-List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Limiting Row Count In a Table??
Date: 2002-12-02 15:28:35
Message-ID: 18578.1038842915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-9?B?x2Hw/Wwg3mVrZXI=?= <cagils(at)biznet(dot)com(dot)tr> writes:
> I want my table to have only one row, if any other row is inserted or this one row is deleted it should give an error and won't let it go.

Why don't you put in the one row, and then REVOKE insert and delete
privileges from everyone (including yourself)?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-12-02 15:34:02 Re: Limiting Row Count In a Table??
Previous Message Uro Gruber 2002-12-02 15:25:58 deny list databases