Limiting Row Count In a Table??

From: Çağıl Şeker <cagils(at)biznet(dot)com(dot)tr>
To: "PostgreSQL-General-List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Limiting Row Count In a Table??
Date: 2002-12-02 15:04:06
Message-ID: 94327A2FE8C87C4C89A82DBE9E7B2B3F086870@beetle.biznet.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is there a way in PG that allows limiting number of rows for a table.

If not maybe there is another way to achieve this:
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.

How can this be done the right way?
Thanks...

Cagil Seker
-----------------
"Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uroš Gruber 2002-12-02 15:13:21 deny list databases
Previous Message Tom Lane 2002-12-02 15:01:21 Re: The old "not using index" question