Re: Limit A Table To 1 Row - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Limit A Table To 1 Row
Date
Msg-id 20020807034208.GA10875@wolff.to
Whole thread Raw
In response to Limit A Table To 1 Row  (<cnliou@eurosport.com>)
List pgsql-sql
On Wed, Aug 07, 2002 at 03:29:50 +0000, cnliou@eurosport.com wrote:
> Hello!
> 
> Corporate table, t1, should contain exact 1 row.
> I strongly believe that there are cleaner versions
> than the following combination of trigger and rule.
> 
> Thank you in advance for any improved version!

Another way to keep someone from inserting a second row is to have a primary
key and a constraint fixing the primary key to a fixed value.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL syntax
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL syntax