Postgres Pro
Downloads
Home   >   mailing lists

Re: Limiting Row Count In a Table?? - Mailing list pgsql-general

From Tom Lane
Subject Re: Limiting Row Count In a Table??
Date
Msg-id 18578.1038842915@sss.pgh.pa.us
Whole thread Raw
In response to Limiting Row Count In a Table??  (Çağıl Şeker <cagils@biznet.com.tr>)
List pgsql-general
Tree view 
=?iso-8859-9?B?x2Hw/Wwg3mVrZXI=?= <cagils@biznet.com.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
andwon'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

pgsql-general by date:

Previous
From: Uro¹ Gruber
Date:
Subject: deny list databases
Next
From: "Marc G. Fournier"
Date:
Subject: PostgreSQL Version 7.3 Released! (repost)